5 Jan 2014

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.