wellr00t3d / automydumper Goto Github PK

Automydumper handles backups, retention and rotation for MySQL, Percona Server and Mariadb servers. It uses Mydumper under the hood.

Configuration takes place in /etc/automydumper.cfg.

Running 'automydumper' ( or waiting for the cron ) is all you need to do to get an actual backup.

By default, backups are placed in /var/backups/automydumper/YYYY-mm-dd.

You can however change the destination by changing the backup_dir_format variable in /etc/automydumper.cfg.

Restoring backups can be done either with myloader ( part of the mydumper package ), or by manually zcat'ing a table backup to mysql. Please refer to the myloader man page for more details. Below are some of the mostly-used use-cases.

myloader -d /var/backups/automydumper/2017-12-31 -o -v 3

myloader -d /var/backups/automydumper/2017-12-31 -o -v 3 -s db1

zcat /var/backups/automydumper/2017-12-31/db1.t1.sql.gz | mysql db1