• mysqldump db_name > outputfile.sql - dumps the database db_name into file outputfile.sql
  • mysql db_name < outputfile.sql - restores file on the server
  • mysqldump -d dump just the database structure, not the data
  • mysqldump --opt db_name | mysql --host=remote_host -C db_name - remote populate a database

-- MattWalsh - 19 Jul 2007