Backing Up mySQL Databases

• Backing Up A Drupal Database, November 2008
• Dumping database to a file:

mysqldump -u chris -h db -p --databases coletta > backup.sql

• Importing an exported database:

mysql -u pierspar -p pierspar_ssdrp01 < pierspar_ssdrp01.sql

• man page for mysql dump is really helpful.