Recover DB after HDD crash
Posted 13 November 2017 - 11:24 AM
I need a piece of advise. My computer crashed, and after the last DB backup I had made some updates to my database, which got lost.
I placed the HDD in an external HDD box and managed to recover all my data. So now I have my wamp folder and subfolders (bin, phpapps, www, …) in a temp folder in my new computer.
Once I have reinstalled the wamp app bundle, is it safe to just copy the folder of my database (bin\database\mysql-5.7.11\data\<my_database>) to the same path? If not, is it possible to first run mysqldump against the DB in the temp folder?
Posted 14 November 2017 - 08:14 PM Best Answer
--all-databases --extended --verboseCopy literally everything from the old data/ directory to the new one.
Posted 14 November 2017 - 08:25 PM
You are quicker than the light... I indeed initially just copied the data of the DB folder. Now all tables are listed. mysqlcheck is running ...
Posted 14 November 2017 - 08:47 PM
Results of mysqlcheck : all tables in all databases are ok, except for the tables of database performance_schema, for which it says "The storage engine for the table doesn't support check". Is this an issue or a normal result for that table ?
Anyway, thank you very much for your help!
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users