Backup Mysql Databases

To backup the Mysql database, we use mysqldump command.
Below are some of the basic commands for mysqldump.

Backup the table structure without the data.
mysqldump database --no-data >db-dump-file.sql

Backup specific databases.
mysqldump --opt database > db-dump-file.sql

Dump everything.
mysqldump --opt --all-databases > total-db-dump-file.sql
mysqldump -u user-id -h host-name --opt --all-databases > total-db-dump-file.sql