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 Area —
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.
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.
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,
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
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:
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.