achilles283
8/28/2013 - 7:10 PM

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