#37 daily backups rotation and backup dirs

[Kirk Marshall]

Hi there,

I'd like to only keep 3 or 4 days worth of mysql dumps using automysqlbackup but I can't see any option to achieve this in /etc/default/automysql?

We have an offsite backup server and some of the databases we backup are so huge that there just isn't enough space to keep a week's worth at any one time.

Can you help with the following?

Our server only requires DAILY backups.
Keep 3 days of DAILY backups then rotate, so automatically remove backups older than 3 days
if possible, don't create WEEKLY and MONTHLY backup dirs in /backups directory as we only need DAILY backups?

Hope you can help!

Many Thanks :)

spawnsworth

[Valerio Pulese]

Edit your automysqlbackup.conf
(/etc/automysqlbackup/automysqlbackup.conf)
Uncomment rotation setting defaults and set them as you prefer.
For example:

# Rotation Settings

# Which day do you want monthly backups? (01 to 31)
# If the chosen day is greater than the last day of the month, it will be done
# on the last day of the month.
# Set to 0 to disable monthly backups.
CONFIG_do_monthly="0"

# Which day do you want weekly backups? (1 to 7 where 1 is Monday)
# Set to 0 to disable weekly backups.
CONFIG_do_weekly="0"

# Set rotation of daily backups. VALUE*24hours
# If you want to keep only today's backups, you could choose 1, i.e. everything older than 24hours will be removed.
CONFIG_rotation_daily=3