AutoMySQLBackup weekly backup modification

moyorakkhi · 05-04-2011, 01:15 PM

Hello,

I'm using AutoMySQLBackup (https://sourceforge.net/projects/automysqlbackup/) script to backup mysql db from several server.I need little help from you who is guru in scripting. I would like to take weekly backup after every 1 week and not every week. i.e. on every 14 days.

This is the weekly backup portion of the script:

Code:

# Weekly Backup
	if [ ${DNOW} = ${DOWEEKLY} ]; then
		${ECHO} Weekly Backup of Database \( ${DB} \)
		${ECHO}
			dbdump "${DB}" "${BACKUPDIR}/weekly/${DB}/${DB}_week.${W}.${DATE}.sql"
			[ $? -eq 0 ] && {
				${ECHO} Rotating 5 weeks Backups...
				${FIND} "${BACKUPDIR}/weekly/${DB}" -mtime +35 -type f -exec ${RM} -v {} \; 
			}
			compression "${BACKUPDIR}/weekly/${DB}/${DB}_week.${W}.${DATE}.sql"
			BACKUPFILES="${BACKUPFILES} ${BACKUPDIR}/weekly/${DB}/${DB}_week.${W}.${DATE}.sql${SUFFIX}"
		${ECHO} ---------------------------------------------------------------------

Kindly help me to modify the script. Thanks for your help in advance.

spankbot · 05-04-2011, 01:31 PM

I would not modify the script. Instead, use cron to only run the script every 14 days.

By default, the automybackup setup instructions tell you to add a simlink in /etc/cron.daily. Instead of doing that, leave the script in a good location (ie, /usr/local/admin/bin) and setup a root cron job to run it every two weeks. Something like so...

Quote:

* * * * 0/2 /usr/local/admin/bin/automysqlbackup

The "0/2" means "every other Sunday".

moyorakkhi · 05-04-2011, 01:42 PM

Quote:

Originally Posted by spankbot

I would not modify the script. Instead, use cron to only run the script every 14 days.

By default, the automybackup setup instructions tell you to add a simlink in /etc/cron.daily. Instead of doing that, leave the script in a good location (ie, /usr/local/admin/bin) and setup a root cron job to run it every two weeks. Something like so...

The "0/2" means "every other Sunday".

Hi, thanks for you advice. If I run the script on every 14 days the daily mysql dump will not be taken. This script runs daily and takes daily, weekly and monthly backup with desired rotation. I'd like to run it daily but instead of taking backup on every saturday or sunday or whatever day select, it'll take backup on every 14 days. Thanks again.

spankbot · 05-04-2011, 02:07 PM

So you want daily backups, as well as a bi-weekly backups? I would consider contacting the author.

moyorakkhi · 05-05-2011, 12:06 AM

Quote:

Originally Posted by spankbot

So you want daily backups, as well as a bi-weekly backups? I would consider contacting the author.

I did actually. Haven't got any response