Skip to content

sschamp/automydumper

 
 

Repository files navigation

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

Configuring Automydumper

Configuration takes place in /etc/automydumper.cfg.

Running Automydumper

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

Flexible backup directories

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

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.

Restoring a full MySQL instance ( all databases, all tables ), overwriting existing tables:

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

Restoring a single database (db1), overwriting existing tables:

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

Restoring a single table 't1' from database db1:

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

About

Mydumper-based MySQL backups

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Shell 100.0%