Thursday, December 6, 2012

How to Back Up a MySQL Database Using mysqldump

0.  Start the command prompt in Windows.

1.  Migrate to the bin folder of the MySQL Database so in my case it's: cd C:\Program Files\MySQL\MySQL Server 5.5\bin

2.  mysqldump -u root -p --databases <databasename> --result-file=c:\dbbackup.sql

Booyah.  Done.  Hopefully.

No comments:

Post a Comment