From http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/
backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql