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.