How to Take Backup Of MySQL/MariaDB and Restore it.

Backup of MySQL database with the native tools is something that most the MySQL admin does. I’ll take you through the backup procedure of MySQL DB using mysqldump command. This procedure is same across all the Linux distribution.

You need a MySQLsql instance up and running. Need Privileges on that database you are trying to backup or root user password with you.

1. Take backup of a Single database on a Linux Server?

All the backing up will done by the “mysqldump” command. In this example we’ll be taking backup of DB “exampledb1 ” and the backup will be stored at “/tmp/exampledb1_exampleserver1.sql” .

mysqldump -u root -ppassword exampledb1 /tmp/exampledb1_exampleserver1.sql