Sunday, July 28, 2013

Backup & Restore MySQL database


Backup & Restore MySQL Database
Environment: MySQL 5


Backup - All Databases
#mysqldump -u root -p --all-databases > /tmp/AllDatabase.sql


Backup - Single Database
#mysqldump -u root -p YourDbName > /tmp/database.sql


Backup - Single Table
#mysqldump -u root -p YourDbName YourTableName> /tmp/table.sql


Restore- Single Table
#mysql -u root -p YourDbName < /tmp/table.sql