Backup and Restore MySQL Databases Using mysqldump

March 14th, 2015 | by chase
Backup and Restore MySQL Databases Using mysqldump
Backups
0

 

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql

 

Reference:¬†http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html’

Leave a Reply

Your email address will not be published. Required fields are marked *