how can i move or recover MySQL database from crashed server to another live server and make it working
How to recover MySQL database from crashed server to another server
JAY
Create a database with the same name on your new server,
Copy your old database
/www/server/data/database_name/all_file
to the directory of the new database
/www/server/data/database_name
Set data file permissions to 660 and restart mysql
i tested this way but i cont see tables in phpmyadmin.
JAY
Is your database file permissions set correctly?
Or I can log in to your panel to check it out for you.
- Edited
yes all are correct where to send your my login details.
ok i sent an email to zhwyeah@gmail.com
thank you for fixing
4 years later
aaPanel_Jose I facing the same issue I have all Databases folders and .frm .ibd files in /www/server/data
but in phpmyadmin this error on every table "wp_posts' doesn't exist in engine"
How i can contact you m.aliraza121@gmail.com
Hello, have you done anything unusual?
aaPanel_Kern No Kern, I just Restart my Contabo Server. please help me, my all websites are stopped to work.
Hello, it seems that it is caused by not stopping mysql properly. It is recommended to find a data recovery company to help you restore it.
a year later
aaPanel_Jose Hi sir, I have the same problem, after copy and set permisson, in myphpadmin dont have any table
aaPanel_Jose Please help me
aaPanel_Jose Can you share the detail of fixing ? I have a problem that not showing any table in phpmyadmin
aaPanel_Kern Hi sir, I have the same problem like above, I copy down anythign and set permission but in myphpadmin no have any table, please help me
Hello,
It is recommended that you provide screenshots to create directories and permissions correctly
Also check whether there is any error message in mysql log