How Do I Back Up My MySQL Database in WAMPServer?

>Locate your MySQL database. Open your WAMPServer root folder,
located at C:wamp by default.


>Next, open the following sub-folders:
“bin,” “mysql,” “mysqlx.x.x” (where x.x.x stands for your MySQL version number) and then “data.”


>Within the data folder you will see all of the MySQL databases created with WAMPServer.



>Copy the folder containing your database. Locate the folder name that matches the name of your database. Right-click the folder and select “Copy.”


>Create the backup of your database. Choose the location where you want to store your back-up database, perhaps a separate folder or on a CD.


>After selecting the location, right-click within the folder window and select “Paste.” The back-up copy of your MySQL database has been created.

Leave a Reply