In database management system, backup is an important part of dealing with databases.
In MySQL/ MariaDB database, the mysqldump command is used to take the backup of the database. It’s designed specifically for backup purpose. Mysqldump can be used to backup a single database, multiple databases and all databases.
Backing up a single database
We can run the following command in the shell prompt to take the back up for a single database.