1

I want to restore my database from /var/lib/mysql/<database>.

I have tried with this process,

1) First, I stop mysql service.

2) After that, I copy my database from /var/lib/mysql/<database> old server to new server /var/lib/mysql/<database>.

3) Change all permission of that database

4) Then, I have restarted MySQL service.

but the result is I have seen all tables but when I click on the tables then there are no data in the table. In the database, I have around 374 tables, but in phpmyadmin I see only 13 tables.

And also table type change innoDb to memory.

enter image description here

Improve this question

1 Answer 1

Reset to default
0

Why don't just use mysqldump? An utility which comes with mysql to dump your data as sql queries and then run them on new database. https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/mysqldump-sql-format.html

But when you upload your data into new database check rows in table core_config_data with config paths web/unsecure/base_url and web/secure/base_url, values of these fields should be your current urls of host (in case domain of your store is changed).

Improve this answer
2
  • Please read the question again. Commented Jun 20, 2018 at 4:22
  • What for? You need to transfer data from one database to another, i gave you option how to do this, you can use it or can not, why should i read your question again which is not associated with magento btw? Commented Jun 20, 2018 at 10:39

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.