5 cents hint – Dump and restore MySQL database on WAMP server

By | 5. April 2017

For backing up and restoring MySQL database on WAMP server no fancy tools are needed. Out of the box command line tools will do all you need:

Dump database :

[path to wamp mysql bin directory]\bin\mysqldump -u[user]-p[password] [database name] > [destination file]

For example

C:\wamp64\bin\mysql\mysql5.6.17\bin\mysqldump -uroot -p mydatabase > c:\temp\mydatabase.sql

 

And restoring same thing back:

[path to wamp mysql bin directory]\bin\mysql.exe -u[user]-p[password] [database name] < [destination file]

For example

C:\wamp64\bin\mysql\mysql5.6.17\bin\mysql.exe -u root -p mydatabase < c:\temp\mydatabase.sql

 

 

Leave a Reply