mysql dump and restore a database

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

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

so if you wanna to see a detail of thie topic. see:
http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/

评论

热门博文