-
Notifications
You must be signed in to change notification settings - Fork 1
sqlbackup
Automatic, incremential backup of your MySQL database while the DB is running. It's using low ressources while backing up.
pyxtrabackup script is configured to run every hour. Backups are stored in /var/backups/mysql
Change automatic behaviour and destination directory accordingly in file /etc/cron.hourly/mysql_backup
pyxtrabackup-restore --base-archive= --incremental-archive= --user=root --uncompressed-archives
In image version >= 2.2 you can run the following command to restore incremental backups easily: mysql_restore /var/backups/mysql//INC/.tar
Every day a new backupfolder is created in /var/backups/mysql with the corresponding directory name based on the current date. Depending on your SD card/USB stick and database size you might run into problems concerning free disk space. Beginning with image v 2.2 the cron script deletes all backups except the newset 5 ones. Change accordingly in /etc/cron.hourly/mysqlbackup or fix issues in one of these ways:
- Change backup folder to a mounted network drive (with nfs or samba). You can also create symlinks to /var/backup/mysql from those drives for your convenience.
- Compress backups by removing the "no-compress" flag in the cron script. Be aware that this increases CPU load significantly for several minutes.