Monday, December 10, 2012

SQL Command to Restore a MySQL Database


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

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

No comments:

Post a Comment