How to Dump a MySQL Database

Posted on January 09, 2008

To obtain the raw production SQL from which you can then load your own development database, for example:

mysqldump -u username -p database_name > dump.sql

To load this dumpfile into a target database:

mysql database_name -p < dump.sql

You’ll be prompted for a password for both. (omit “-p” if your database does not require a password)