In this tutorial we are going to learn how to restore single MySQL database from a mysql backup file, which contains multiple databases.
What if you backed up all databases in your MySQL/MariaDB Server using –all-databases option, and now you want to restore one database from the all database backup file?
The Linux mysqldump command is a mysql client use to backup MySQL/MariaDB Databases. Typically mysqldump command use to export MySQL database to into a text file as a backup, But it has several other options. For example, we can use mysqldump command to backup tables from one database to another or we can backup database from one MySQL Server to another.
In this tutorial we will learn Some useful mysqldump database backup options with examples.