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
# database.table
# 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.
Tweet
Hello,
Thanks for the updates to the script really cool! I’m running into problems with the script though:
line 507: {split($0,a,”.”) ; print a[1] }: command not found
I have no idea where it is coming from. No modifications have been made to the file. I am using PHP 5.3.3, Debian Squeeze, MySQL mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (i486) using readline 6.1.
Any help would be appreciated!
Link | July 18th, 2011 at 10:40 am
It would be really nice if you would sync your script with Debian repository..
Please see comments here:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=594841
Link | April 12th, 2012 at 4:53 pm
Will do. My code fills my need and I hopped to get them in gear and update their code. It worked. I guess now it “tag I’m it” :-)
Link | April 16th, 2012 at 3:00 pm