RU|EN

Knowledge base

Auto-backup service: database backup configuration

By default databases are not included in the backup copies of Auto-backup service.

To configure database backup you need to add database server login details in the auto-backup configuration file. If you need help to complete the auto-backup configuration, feel free to contact us in your Client AreaSupport, Support tickets section. We will help to add the databases in the backup.

For the manual configuration, you need to connect to the server by SSH or VNC.

Where you can find the database server login details

Usually, all required login details listed in /root/.my.cnf configuration file.

As an alternative way, you can add a new database server user with database backup permissions. To create «dbuser» user with «dbuserpassword» password open the mysql client and enter the request:

CREATE USER ‘dbuser’@’localhost’ IDENTIFIED BY 'dbuserpassword';

To provide permissions for new user enter the next request:

GRANT ALL PRIVILEGES ON *.* TO ‘dbuser’@’localhost’;

If the login details for mysql are lost, try to reset mysql password.

Auto-backup configuration file settings

After you found and copied the database server login details, you need to add it to Auto-backup service configuration file. To start open the file /opt/autobackup/config.yml in any console editor (for example, vim or nano).

There is the large list of different settings:

isptar: http://rep.fvds.ru/utils/isptar
countbackups: 7
storagemaxsize: 100
ispmgruser: 
ftp_server: 
ftp_port: "21"
ftp_user: 
ftp_password: 
ftp_retrycount: 5
slicesize: 100
backup_paths:
 - /var/www
 - /etc
 - /home
mysql:
   mysql_enable: false
   mysql_user: root
   mysql_pass: ""
   mysql_server: ""
   databases:
     - alldatabases

To configure the database backup edit these parameters:

  • mysql_user — enter database server user name
  • mysql_pass — enter database server user password
  • mysql_enable — replace false with  true

If your database server has the specific configuration (with a manual build or working from Docker container), you need also to edit mysql_server field with database server TCP address or path to Unix-socket. Fill pattern:

  • TCP:
    mysql_server: "tcp(192.168.1.55:3306)"
  • UNIX-socket:
    mysql_server: "unix(/var/run/mariadb.sock)"

By default system will backup all databases. If you need to limit that list, edit the databases parameter. Enter the list of databases, which you want to save in backups, or leave - alldatabases to save all databases by default.

When you will complete the editing, save the configuration file. The next backup by schedule will contain databases dumps.

Attention: if there will be errors or wrong login details in the auto-backup configuration file, it will be automatically reconfigured by default on the next day. 

Return to category