backup: mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
Restore is as follows:
# mysql -u root -ptmppassword mysql> create database sugarcrm; Query OK, 1 row affected (0.02 sec) # mysql -u root -ptmppassword sugarcrm < /tmp/sugarcrm.sql # mysql -u root -p[root_password] [database_name] < dumpfilename.sql
Reference: http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/