How to Backup and Restore MySQL DB

Related: Ghost Blog

Backup

mysqldump -u root -p --databases ghost_production > ghost_production_backup.sql

Restore

mysql -u root -pYOUR_PASSWORD destination_db < db_backup.sql

References

The complete mysqldump guide (with examples)