Backup & Restore MySQL Database
Environment: MySQL 5
Backup - All Databases
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
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