Hello.
In this topic I need Magento experts help about Migrate my old server to new server. I want to start from DB.
On a server I have Magento 1.2 and I like to migrate it to my new server that using Magento 2.X. On old server, my DB scheme is like below:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| livezilla |
| mysql |
| performance_schema |
| store |
| temp |
| test |
+--------------------+
7 rows in set (0.05 sec)
My DB is "store". I used below command for export my DB:
# mysqldump -u root -p --opt store > store.sql
On new server, I created a DB as below:
CREATE DATABASE store;
CREATE USER 'magento' IDENTIFIED BY 'Pass';
GRANT ALL PRIVILEGES ON store.* TO magento@localhost identified by 'Pass';
FLUSH PRIVILEGES;
Then I used below command for import the DB:
# mysql -u root -p store < store.sql
Is it OK? If yes, How can I see my DB information via Magento admin page?
Thank you.