AutoMySQLBackup / Discussion / Open Discussion: Use symbolic link in latest

I like using the latest option but it makes a physical copy. I have modified the code a little so it will only create a symbolic link to the latest file rather than double the space required.
Replace everything after this line:
# Compression function plus latest copy
With this code:
SUFFIX=""
compression () {
if [ "$COMP" = "gzip" ]; then
    gzip -f "$1"
    echo
    echo Backup Information for "$1"
    gzip -l "$1.gz"
    SUFFIX=".gz"
elif [ "$COMP" = "bzip2" ]; then
    echo Compression information for "$1.bz2"
    bzip2 -f -v $1 2>&1
    SUFFIX=".bz2"
else
    echo "No compression option set, check advanced settings"
fi
#if [ "$LATEST" = "yes" ]; then
#   cp $1$SUFFIX "$BACKUPDIR/latest/"
#fi 
if [ "$LATEST" = "yes" ]; then
    ln -s $1$SUFFIX "$BACKUPDIR/latest/$2$SUFFIX"
fi
return 0
}
# Run command before we begin
if [ "$PREBACKUP" ]
    then
    echo ======================================================================
    echo "Prebackup command output."
    echo
    eval $PREBACKUP
    echo
    echo ======================================================================
    echo
fi
if [ "$SEPDIR" = "yes" ]; then # Check if CREATE DATABSE should be included in Dump
    if [ "$CREATE_DATABASE" = "no" ]; then
        OPT="$OPT --no-create-db"
    else
        OPT="$OPT --databases"
    fi
else
    OPT="$OPT --databases"
fi
# Hostname for LOG information
if [ "$DBHOST" = "localhost" ]; then
    HOST=`hostname`
    if [ "$SOCKET" ]; then
        OPT="$OPT --socket=$SOCKET"
    fi
else
    HOST=$DBHOST
fi
# If backing up all DBs on the server
if [ "$DBNAMES" = "all" ]; then
        DBNAMES="`mysql --user=$USERNAME --password=$PASSWORD --host=$DBHOST --batch --skip-column-names -e "show databases"| sed 's/ /%/g'`"
    # If DBs are excluded
    for exclude in $DBEXCLUDE
    do
        DBNAMES=`echo $DBNAMES | sed "s/\b$exclude\b//g"`
    done
        MDBNAMES=$DBNAMES
fi

echo ======================================================================
echo AutoMySQLBackup VER $VER
echo http://sourceforge.net/projects/automysqlbackup/
echo 
echo Backup of Database Server - $HOST
echo ======================================================================
# Test is seperate DB backups are required
if [ "$SEPDIR" = "yes" ]; then
echo Backup Start Time `date`
echo ======================================================================
    # Monthly Full Backup of all Databases
    if [ $DOM = "01" ]; then
        for MDB in $MDBNAMES
        do

             # Prepare $DB for using
                MDB="`echo $MDB | sed 's/%/ /g'`"
            if [ ! -e "$BACKUPDIR/monthly/$MDB" ]       # Check Monthly DB Directory exists.
            then
                mkdir -p "$BACKUPDIR/monthly/$MDB"
            fi
            echo Monthly Backup of $MDB...
                dbdump "$MDB" "$BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql"
                compression "$BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql" "${MDB}_$DATE.$M.$MDB.sql"
                BACKUPFILES="$BACKUPFILES $BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql$SUFFIX"
            echo ----------------------------------------------------------------------
        done
    fi
    for DB in $DBNAMES
    do
    # Prepare $DB for using
    DB="`echo $DB | sed 's/%/ /g'`"

    # Create Seperate directory for each DB
    if [ ! -e "$BACKUPDIR/daily/$DB" ]      # Check Daily DB Directory exists.
        then
        mkdir -p "$BACKUPDIR/daily/$DB"
    fi

    if [ ! -e "$BACKUPDIR/weekly/$DB" ]     # Check Weekly DB Directory exists.
        then
        mkdir -p "$BACKUPDIR/weekly/$DB"
    fi

    # Weekly Backup
    if [ $DNOW = $DOWEEKLY ]; then
        echo Weekly Backup of Database \( $DB \)
        echo Rotating 5 weeks Backups...
            if [ "$W" -le 05 ];then
                REMW=`expr 48 + $W`
            elif [ "$W" -lt 15 ];then
                REMW=0`expr $W - 5`
            else
                REMW=`expr $W - 5`
            fi
        eval rm -fv "$BACKUPDIR/weekly/$DB_week.$REMW.*" 
        echo
            dbdump "$DB" "$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql"
            compression "$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql" "${DB}_week.$W.$DATE.sql"
            BACKUPFILES="$BACKUPFILES $BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql$SUFFIX"
        echo ----------------------------------------------------------------------

    # Daily Backup
    else
        echo Daily Backup of Database \( $DB \)
        echo Rotating last weeks Backup...
        eval rm -fv "$BACKUPDIR/daily/$DB/*.$DOW.sql.*" 
        echo
            dbdump "$DB" "$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql"
            compression "$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql" "${DB}_$DATE.$DOW.sql"
            BACKUPFILES="$BACKUPFILES $BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql$SUFFIX"
        echo ----------------------------------------------------------------------
    fi
    done
echo Backup End `date`
echo ======================================================================
else # One backup file for all DBs
echo Backup Start `date`
echo ======================================================================
    # Monthly Full Backup of all Databases
    if [ $DOM = "01" ]; then
        echo Monthly full Backup of \( $MDBNAMES \)...
            dbdump "$MDBNAMES" "$BACKUPDIR/monthly/$DATE.$M.all-databases.sql"
            compression "$BACKUPDIR/monthly/$DATE.$M.all-databases.sql" "$DATE.$M.all-databases.sql"
            BACKUPFILES="$BACKUPFILES $BACKUPDIR/monthly/$DATE.$M.all-databases.sql$SUFFIX"
        echo ----------------------------------------------------------------------
    fi
    # Weekly Backup
    if [ $DNOW = $DOWEEKLY ]; then
        echo Weekly Backup of Databases \( $DBNAMES \)
        echo
        echo Rotating 5 weeks Backups...
            if [ "$W" -le 05 ];then
                REMW=`expr 48 + $W`
            elif [ "$W" -lt 15 ];then
                REMW=0`expr $W - 5`
            else
                REMW=`expr $W - 5`
            fi
        eval rm -fv "$BACKUPDIR/weekly/week.$REMW.*" 
        echo
            dbdump "$DBNAMES" "$BACKUPDIR/weekly/week.$W.$DATE.sql"
            compression "$BACKUPDIR/weekly/week.$W.$DATE.sql" " week.$W.$DATE.sql"
            BACKUPFILES="$BACKUPFILES $BACKUPDIR/weekly/week.$W.$DATE.sql$SUFFIX"
        echo ----------------------------------------------------------------------

    # Daily Backup
    else
        echo Daily Backup of Databases \( $DBNAMES \)
        echo
        echo Rotating last weeks Backup...
        eval rm -fv "$BACKUPDIR/daily/*.$DOW.sql.*" 
        echo
            dbdump "$DBNAMES" "$BACKUPDIR/daily/$DATE.$DOW.sql"
            compression "$BACKUPDIR/daily/$DATE.$DOW.sql" "$DATE.$DOW.sql"
            BACKUPFILES="$BACKUPFILES $BACKUPDIR/daily/$DATE.$DOW.sql$SUFFIX"
        echo ----------------------------------------------------------------------
    fi
echo Backup End Time `date`
echo ======================================================================
fi
echo Total disk space used for backup storage..
echo Size - Location
echo `du -hs "$BACKUPDIR"`
echo
echo ======================================================================
echo If you find AutoMySQLBackup valuable please make a donation at
echo http://sourceforge.net/project/project_donations.php?group_id=101066
echo ======================================================================
# Run command when we're done
if [ "$POSTBACKUP" ]
    then
    echo ======================================================================
    echo "Postbackup command output."
    echo
    eval $POSTBACKUP
    echo
    echo ======================================================================
fi
#Clean up IO redirection
exec 1>&6 6>&-      # Restore stdout and close file descriptor #6.
exec 1>&7 7>&-      # Restore stdout and close file descriptor #7.
if [ "$MAILCONTENT" = "files" ]
then
    if [ -s "$LOGERR" ]
    then
        # Include error log if is larger than zero.
        BACKUPFILES="$BACKUPFILES $LOGERR"
        ERRORNOTE="WARNING: Error Reported - "
    fi
    #Get backup size
    ATTSIZE=`du -c $BACKUPFILES | grep "[[:digit:][:space:]]total$" |sed s/\s*total//`
    if [ $MAXATTSIZE -ge $ATTSIZE ]
    then
        BACKUPFILES=`echo "$BACKUPFILES" | sed -e "s# # -a #g"` #enable multiple attachments
        mutt -s "$ERRORNOTE MySQL Backup Log and SQL Files for $HOST - $DATE" $BACKUPFILES $MAILADDR < $LOGFILE     #send via mutt
    else
        cat "$LOGFILE" | mail -s "WARNING! - MySQL Backup exceeds set maximum attachment size on $HOST - $DATE" $MAILADDR
    fi
elif [ "$MAILCONTENT" = "log" ]
then
    cat "$LOGFILE" | mail -s "MySQL Backup Log for $HOST - $DATE" $MAILADDR
    if [ -s "$LOGERR" ]
        then
            cat "$LOGERR" | mail -s "ERRORS REPORTED: MySQL Backup error Log for $HOST - $DATE" $MAILADDR
    fi  
elif [ "$MAILCONTENT" = "quiet" ]
then
    if [ -s "$LOGERR" ]
        then
            cat "$LOGERR" | mail -s "ERRORS REPORTED: MySQL Backup error Log for $HOST - $DATE" $MAILADDR
            cat "$LOGFILE" | mail -s "MySQL Backup Log for $HOST - $DATE" $MAILADDR
    fi
else
    if [ -s "$LOGERR" ]
        then
            cat "$LOGFILE"
            echo
            echo "###### WARNING ######"
            echo "Errors reported during AutoMySQLBackup execution.. Backup failed"
            echo "Error log below.."
            cat "$LOGERR"
    else
        cat "$LOGFILE"
    fi  
fi
if [ -s "$LOGERR" ]
    then
        STATUS=1
    else
        STATUS=0
fi
# Clean up Logfile
eval rm -f "$LOGFILE"
eval rm -f "$LOGERR"
exit $STATUS
Very useful script!
Use symbolic link in latest

Automatic MySQL Backup

Forums

Help

Use symbolic link in latest

Use symbolic link in latest

Automatic MySQL Backup

Forums

Help

Use symbolic link in latest document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Use symbolic link in latest
