Deprecated

Search our articles or browse by category below

[deprecated] How to backup MySQL on Linux

August 09, 2016 Anders Andersen


Note: This article is deprecated since version 1.6 of the Linux agent. But are still useful if running old versions and offline configuration. Regarding any information please contact the support on support@backupbird.com


Edit the config file on the server

sudo nano /etc/backupbird/conf.toml

Insert the following into the configuration file, and add your infomation.

[[database]]
driver = "mysql"
hostname = "localhost"
username = ""
password = ""
database = ""
port = "3306"
* The agent uses mysqldump to make the backup. Click here for mysql-client installation

You can backup all databases for the user by defining the database as so:
database = "*"

In some cases you need to backup more than one mysql database. Then you just insert a another block in the configuration

[[database]]
driver = "mysql"
hostname = "localhost"
username = ""
password = ""
database = ""
port = "3306"

[[database]]
driver = "mysql"
hostname = "localhost"
username = ""
password = ""
database = ""
port = "3306"


Related articles :

MySQL backup

MySQL to Amazon S3

Linux server backup