Friday, December 17, 2010

Mysql Dump and restore single database

Use the following command to dump and restore mysql database

mysqldump -u root -p dbName  > /var/www/dbBackup.sql
mysql -u root -p dbName < /var/www/dbBackup.sql

No comments:

Post a Comment