How to backup and restore MySQL database

To backup MySQL database, we use MySQLDump utiliti.

mysqldump [options] db_name [tables]
mysqldump [options] --databases db_name1 [db_name2 db_name3...]
mysqldump [options] --all-databases

For example:
mysqldump --opt mydatabase > backup-file.sql

To restore MySQL database we use MySQL shell:
mysql -uuser_name -pyour_pass mydatabaze < backup-file.sql