phdphd Posted November 13, 2017 Share Posted November 13, 2017 Hi All 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? Thanks ! Quote Link to comment https://forums.phpfreaks.com/topic/305648-recover-db-after-hdd-crash/ Share on other sites More sharing options...
requinix Posted November 13, 2017 Share Posted November 13, 2017 You can't run mysqldump unless you have a running database. Copy all the data files and use mysqlcheck to look for errors. Quote Link to comment https://forums.phpfreaks.com/topic/305648-recover-db-after-hdd-crash/#findComment-1553746 Share on other sites More sharing options...
phdphd Posted November 14, 2017 Author Share Posted November 14, 2017 I copied all the data files. In phpmyadmin, the database is listed, along with the table names, but if I click a table name, I get a "table does not exist" error. This is confirmed with mysqlcheck (for all tables). Quote Link to comment https://forums.phpfreaks.com/topic/305648-recover-db-after-hdd-crash/#findComment-1553803 Share on other sites More sharing options...
Solution requinix Posted November 14, 2017 Solution Share Posted November 14, 2017 Did you copy all the files? Each table has 2-3 files, and InnoDB has other stuff. Did you do mysqlcheck with --all-databases --extended --verboseCopy literally everything from the old data/ directory to the new one. Quote Link to comment https://forums.phpfreaks.com/topic/305648-recover-db-after-hdd-crash/#findComment-1553805 Share on other sites More sharing options...
phdphd Posted November 14, 2017 Author Share Posted November 14, 2017 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 ... Quote Link to comment https://forums.phpfreaks.com/topic/305648-recover-db-after-hdd-crash/#findComment-1553807 Share on other sites More sharing options...
phdphd Posted November 14, 2017 Author Share Posted November 14, 2017 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! Quote Link to comment https://forums.phpfreaks.com/topic/305648-recover-db-after-hdd-crash/#findComment-1553809 Share on other sites More sharing options...
requinix Posted November 14, 2017 Share Posted November 14, 2017 performance_schema is special. Don't worry about it. Quote Link to comment https://forums.phpfreaks.com/topic/305648-recover-db-after-hdd-crash/#findComment-1553810 Share on other sites More sharing options...
phdphd Posted November 14, 2017 Author Share Posted November 14, 2017 Great ! Quote Link to comment https://forums.phpfreaks.com/topic/305648-recover-db-after-hdd-crash/#findComment-1553811 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.