[MySQL] MySQL backup and restore

Backup

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

– OR –

# mysqldump -u root -p --all-database > backup.sql

– OR –

# mysqldump -u root -p [database_name] --tables [table_name] > backup.sql

---

Restore

# mysql -u root -p < backup.sql

– OR –

# mysql -u root -p [database_name] < backup.sql