I spent my day doing updates to the automysqlbackup script. Here is some of what I’ve added over the last year.
The bug number fixes are from SourceForge. https://sourceforge.net/tracker/?atid=628964&group_id=101066&func=browse
# 2.5.5 MTG – (2011-07-21)
# – Bug – Typo Ureadable Unreadable config file line 424 – ID: 3316825
# – Bug – Change “#!/bin/bash” to “#!/usr/bin/env bash” – ID: 3292873
# – Bug – problem with excludes – ID: 3169562
# – Bug – Total disk space on symbolic links – ID: 3064547
# – Added DEBUG option to only print the commands that will be executed.
# – Bug – WHICH command didn’t work if there was a WHICH alias.
# VER 2.5.4: MTG – (2011-01-28)
# – fixed bug in rsync process.
# – Added the ability to backup only a single table by naming the table like
# VER 2.5.2-02: MTG – (2010-12-29)
# – Added file promission settings (chmod) to directory and file creation points.
# VER 2.5.2-01: MTG – (2010-11-06)
# – Added ‘-R’ to the mysqldump options to include stored procedures in the backup
# by default. (suggested by Zack Evans)
# VER 2.5.2: MTG – (2010-11-04)
# – Added option to archive (rsync) the local backup files to a remote locations
# using the COPYDIR varaible.
# – Added option to copy files into a directory based on the hostname using the
# variable HOSTNAME. This allows the script to be run from a shared storage directory
# ( SBM, NFS, NetApp) the data to be kept seperate places.
# – Added option to backup all database schemas only using variable FULLSCHEMA.
# – Added option to backup MySQL configuration file, my.cnf and remove files older then seven
# days from the BACKUPDIR directory.
# – Added –master-data=2 and –single-transaction to include a comment with the master server’s
# the binary log coordinates. If used the CHANGE_MASTER_TO line must be uncommented.
The project is at https://sourceforge.net/projects/automysqlbackup/
You can download my version at http://www.mysqlfanboy.com/Files/automysqlbackup.sh
Email me or leave a comment if you have any trouble.