mysql database backup

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/

Leave a Reply