mercredi 25 mars 2015

How to restore mysql database in XAMPP using backup of mysql folder?


I have a backup of the entire xampp/mysql folder. How can I use it to recover my old db on a fresh installation of XAMPP?


Simply copying the old xampp/mysql folder to new xampp leads to mysql errors like:



InnoDB: Table veno/sls37_finder_links_termsc in the InnoDB data dictionary has tablespace id 1171, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.






Aucun commentaire:

Enregistrer un commentaire