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 ! Link to comment 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. Link to comment 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). Link to comment Share on other sites More sharing options...
requinix Posted November 14, 2017 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. Link to comment 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 ... Link to comment 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! Link to comment 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. Link to comment Share on other sites More sharing options...
phdphd Posted November 14, 2017 Author Share Posted November 14, 2017 Great ! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.