cancel
Showing results for 
Search instead for 
Did you mean: 

Database scheme.

Database scheme.

Hello.
I want to move Magento from an old server to new one but I don't know which DB must be export. It my DB on old server:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| livezilla |
| mysql |
| performance_schema |
| store |
| temp |
| test |
+--------------------+
mysql> select user from mysql.user;
+-----------+
| user |
+-----------+
| jason |
| root |
| jason |
| jason |
| root |
| livezilla |
| magento |
| root |
+-----------+

1- On old server, DB name is "store", when I exported it by " mysqldump" command then on new server first of all, I must create a DB with the name "store" then import backup or it is not needed?
2- the DB username on new server must be same as the DB username on old server? For example, on new server the DB username must be "jason"?

Thank you.