MySQL DB backup and restore

Backup all databases

    mysqldump -u root -p --all-databases > /var/mysql/backup/all.sql

Backup single database

    mysqldump -u root -p dbname > /var/mysql/backup/db.sql

Backup multiple databases

    mysqldump -u root -p --databases db1 db2 db3 > /var/mysql/backup/dbs.sql

Backup only specific tables in a database

    mysqldump -u root -p dbname tablename > /var/mysql/backup/table.sql

Restore database

    mysql -u root -p dbname < /var/mysql/backup/db.sql