How to quickly back up MySQL in WAMP

shape
shape
shape
shape
shape
shape
shape
shape

Instead of dumping all the tables, as an alternative we can copy the necessary files from the MySQL “data” folder, and then restore these files in your new WAMP installation.

 

Copy all the files with the prefix “ib” and all the folders that correspond to the databases you want to back up, just as I did in the image above. Then just paste these files into your new WAMP installation, in my case “B:\wamp64backup\bin\mysql\mysql5.7.14\data” .

NOTE: Remember to turn off WAMP before carrying out the above procedure.

Leave a Reply

Your email address will not be published. Required fields are marked *

Latest news

Latest news directly from our blog.