- Updated README and removed check for README changes from install script
- add option to pass the '--flush-logs' flag to mysqldump from @peterdutton
- Fixed install script after README rename @pmontepagano
- Last update from Sourceforge
- Removing mkfifo commands, thereby improving portability.
- Fixing not working table exclude feature for wildcards.
- Changed code to make it more portable, thereby resolving FreeBSD issue.
- Added multicore support for bzip and gzip2.
- Fixed error in README file.
- Added differential backup method.
- Added user-friendly method to recreate full backups out of differential ones.
- Changed paramters, with which the script can be called, to make the new methods available.
- Fixed some bugs.
- Added possibility to backup local files.
- Added full schema backup.
- Added master-data option.
- Fixed some bugs.
- REMOVED: Implementation of Variables containing full path to binaries to avoid possibly confusion with aliases or builtins. (by Johannes Kolter) Inside a bash script no aliases are used! This didn't make ANY sense! Thereby resolved bug item #3074425.
- Changed some variables to be arrays, i.e. lists, and removed the ugly sed stuff. Fixed bug item #3169562
- Added check for weekly and monthly backups, so that they are unique per day. bug item #3185389
- Changed SHEBANG to #!/usr/bin/env bash for portability reasons. bug item #3292873
- Changed config file structure: read /etc/automysqlbackup/mysqlbackup.conf, if supplied read configfile parameter (no more -c or sth. like that, just the name of the file!), whatever isn't set yet, set in here to default values.
- bug item #3110715: create a file in /etc/cron.d/daily and call the script from in there, i.e. place the script in /usr/local/bin
- bug item #3082899: the PATH variables are different in ssh, you have to supply the complete path
- Fixed bug item #3064547, suggestion accepted.
- Fixed bug item #3031023, suggestion accepted.
- Fixed bug item #3030604, resolved due to design correction.
- Fixed bug item #3025849, as long as basename is in $PATH on your system.
- Fixed bug item #3030478.
- bug item #3054633: .muttrc entry save=yes will result in saving sent files!
- Feature request item #1538588.
- Feature request item #1538138.
- Feature request item #1538142.
- Feature request item #1541843 was already included.
- Feature request item #2808012.
- Feature request item #2831465.
- Feature request item #3052484. Mysqldump already has an ssl option.
- Feature request item #3190079. I hope cleaning up everything older than 24 hours as a lower limit is good enough.
- Feature request item #3284779 was already included. See CONFIG_mysql_dump_latest.
- Feature request item #3053623.
- Fixed bug where files would not email correctly (Fix by Jesse Vaughan)
- Added section to encrypt .gz and .bz2 files using openssl (added by Jesse Vaughan)
- Fixed pathname bug item #3025849 (by Johannes Kolter)
- Added support for default and optional config file (by Johannes Kolter)
- Rotating after backup was successful whith find(1) (by Johannes Kolter)
- Implementation of Variables containing full path to binaries to avoid possibly confusion with aliases or builtins. (by Johannes Kolter)
- Fixed bug where weekly backups were not being rotated. Added rotation of 5 monthly backups Now all old backups are deleted, not only the most recent one (inspired by [email protected])
- Use Debian special-file to access database (by Johannes Kolter)
- Fixed bug ID: 1438565 Moved IO redirection to a place before decicions are made and actions are taken. (inspired by Derk Bernhardt)
- Fixed bug ID: #3000316 (reported by Sascha Feldhorst)
- Fixed bug ID: #1529458 (reported by Natalie ( njwood ))
- Fixed bug ID: #1548919 (reported by Piotr Kuczynski)
- Added support for setting MAXIMUM_PACKET_SIZE and CONFIG_mysql_dump_socket parameters (suggested by Yvo van Doorn)
- Fixed bug where weekly backups were not being rotated. (Fix by wolf02)
- Added hour an min to backup filename for the case where backups are taken multiple
- times in a day. NOTE This is not complete support for mutiple executions of the script
- in a single day.
- Added MAILCONTENT="quiet" option, see docs for details. (requested by snowsam)
- Updated path statment for compatibility with OSX.
- Added "CONFIG_mysql_dump_latest" to additionally store the last backup to a standard location. (request by Grant29)
- Better error handling and notification of errors (a long time coming)
- Compression on Backup server to MySQL server communications.
- Changed from using depricated "-N" to "--skip-column-names".
- Added ability to have compressed backup's emailed out. (code from Thomas Heiserowski)
- Added maximum attachment size setting.
- Fixed a bug in daily rotation when not using gzip compression. (Fix by Rob Rosenfeld)
- Switched to using IO redirection instead of pipeing the output to the logfile.
- Added choice of compression of backups being gzip of bzip2.
- Switched to using functions to facilitate more functionality.
- Added option of either gzip or bzip2 compression.
- Another fix for spaces in the paths (fix by Thomas von Eyben)
- Fixed bug when using PREBACKUP and POSTBACKUP commands containing many arguments.
- Small bug fix to handle spaces in LOGFILE path which contains spaces (reported by Thomas von Eyben)
- Updated docs to mention that Log email can be sent to multiple email addresses.
- Added option to make backups restorable to alternate database names
- meaning that a copy of the database can be created (Based on patch by Rene Hoffmann)
- Seperated options into standard and advanced.
- Removed " from single file dump DBMANES because it caused an error but
- this means that if DB's have spaces in the name they will not dump when CONFIG_mysql_dump_use_separate_dirs=no.
- Added -p option to mkdir commands to create multiple subdirs without error.
- Added disk usage and location to the bottom of the backup report.
- Fixed an issue where weelky backups would only work correctly if server
- locale was set to English (issue reported by Tom Ingberg)
- used "eval" for "rm" commands to try and resolve rotation issues.
- Changed name of status log so multiple scripts can be run at the same time.
- Added PREBACKUP and POSTBACKUP command functions. (patch by markpustjens)
- Added support for backing up DB's with Spaces in the name.
- (patch by markpustjens)
- Added the ability to exclude DB's when the "all" option is used.
- (Patch by kampftitan)
- Project moved to Sourceforge.net
- Added support for backing up "all" databases on the server without
- having to list each one seperately in the configuration.
- Added DB restore instructions.
- Added server name to the backup log so logs from multiple servers
- can be easily identified.
- Small Bug fix in monthly report. (Thanks Stoyanski)
- Added option to email log to any email address. (Inspired by Stoyanski)
- Changed Standard file name to .sh extention.
- Option are set using yes and no rather than 1 or 0.
- Added the ability to have all databases backup to a single dump
- file or seperate directory and file for each database.
- Output is better for log keeping.
- Bug fix for daily directory (Added in version 0.5) rotation.
- Added "daily" directory for daily backups for neatness (suggestion by Jason)
- Added CONFIG_mysql_dump_host option to allow backing up a remote server (Suggestion by Jason)
- Added "--quote-names" option to mysqldump command.
- Bug fix for handling the last and first of the year week rotation.
- Added the abaility for the script to create its own directory structure.
- Changed Naming of Weekly backups so they will show in order.
- Corrected weekly rotation logic to handle weeks 0 - 10
- Initial Release