To backup and restore a MySQL database

To backup a MySQL database:

mysqldump –-user username –password=password database_name > dumpfile.sql

To restore the database:

mysql -u username -ppassword database_name < dumpfile.sql

There is no space between the -p and password.

Further options are available, you can find out more at www.devshed.com.

This entry was posted on Tuesday, August 28th, 2007 at 7:42 pm and is filed under mysql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.