Monday, November 26, 2007

MySQL Backup & Restore

Just wanted to document how to backup and restore my shiny new MySQL database since I’ve got some real data in it.

 

Backup:

mysqldump -u sadmin -p pass21 Customers > custback.sql

 

Restore:

mysql -u sadmin -p pass21 Customers < custback.sql

No comments: