Menu

#45 daily backup rotation not working with differential backups enabled

v1.0 (example)
open
nobody
None
5
2017-01-23
2017-01-23
No

Hello

I am running version 3.0. Daily backup rotation does not seem to be working with differential backups enabled

looks like there is a problem with the function "process_dbs"

below lines in "process_dbs" works for weekly and monthly rotations only


if (( $ret == 0 )); then
echo "Rotating $(( ${rotation}/${rotationdivisor} )) ${rotationstring} backups for ${name}"
if (( $CONFIGdryrun )); then
find "${CONFIGbackupdir}/${subfolder}${subsubfolder}" -mtime +"${rotation}" -type f -exec echo "dry-running: rm" {} \;
else
find "${CONFIGbackupdir}/${subfolder}${subsubfolder}" -mtime +"${rotation}" -type f -exec rm {} \;
fi
filespostprocessing "$cfname"
tmpflags=$?; var=; (( $tmpflags & $flagsfilespostprocessingsuccessencrypt )) && var=.enc
backupfiles=( "${backupfiles[@]}" "${cfname}${var}" )
else
let "E |= $Edbdumpfailed"
echo "dbdump with parameters \"${CONFIGdbnames[@]}\" \"${cfname}\" failed!"
fi


the following settings are configured in the automysqlbackup.conf file

CONFIG_do_monthly="31"
CONFIG_do_weekly="6"
CONFIG_rotation_daily=21
CONFIG_rotation_weekly=35
CONFIG_rotation_monthly=150
CONFIG_mysql_dump_port=3306
CONFIG_mysql_dump_single_transaction='yes'
CONFIG_mysql_dump_full_schema='no'
CONFIG_mysql_dump_dbstatus='yes'
CONFIG_mysql_dump_use_separate_dirs='yes'
CONFIG_mysql_dump_compression='gzip'
CONFIG_mysql_dump_differential='yes'
CONFIG_encrypt='no'

has anyone got a fix for this ?

thanks
Ajay

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.