Changelog for
mysql-backupscript-2.0.8-lp155.6.3.noarch.rpm :
* Sun Sep 10 2023 Georg Pfuetzenreuter
- Switch to MariaDB tooling
* Thu Dec 09 2021 Lars Vogdt - add explicit --databases \"db\" to the mysqldump line
* Wed Nov 10 2021 Lars Vogdt - use \'--master-data=2\' option so that binary log file/pos is printed around line number 25 at the top of the backup in case you want to use the backup to create a replica. Using --master-data=2 is safer than --master-data=1 as the “CHANGE MASTER TO” statement is written as a comment, thus, restoring the backup won’t override any existing replication config
* Mon Oct 25 2021 Lars Vogdt - update to 2.0.8: + enhanced default dump options and make them configurable. Added options:
* --add-drop-database and --add-drop-table (replace the former manual entries)
* --add-drop-trigger
* --apply-slave-statements
* --dump-date
* --extended-insert
* --flush-logs
* --flush-privileges
* --include-master-host-port
* --master-data This should allow to use the dump also to setup a slave server directly.
* Tue Feb 16 2021 roAATTsuse.de- add new config variable COMPRESS_AFTER_UNLOCK defaulting to previous behaviour with \"no\". If set to \"yes\" compression will only be done after post dump scripts have run to shorten the time the database is locked
* Mon Jul 06 2020 larsAATTlinux-schulserver.de - 2.0.7- update to 2.0.7: + only send out final nsca message if USE_NSCA is enabled (yes)
* Mon Apr 20 2020 larsAATTlinux-schulserver.de - 2.0.6- switch to Productivity/Archiving/Backup RPM group
* Fri Feb 14 2020 larsAATTlinux-schulserver.de - 2.0.6- use utf8mb4 as default character set- include stored routines
* Tue Jan 07 2020 larsAATTlinux-schulserver.de - 2.0.5- update to 2.0.5: Added NSCA support. + added configurable Email address in the /etc/sysconfig/mysql-backup file, to allow to sent to other Email addresses than root + added needed configuration options for NSCA, which allows to send messages to remote monitoring systems (like Nagios or Icinga) => the script will send messages on success (including some performance data for the time needed) and on failures
* Wed Jan 01 2020 larsAATTlinux-schulserver.de - 2.0.4- update to 2.0.4 Added the possibility to execute scripts before and after the backup is done. Packaged 4 example scripts in /usr/share/doc/packages/mysql-backupscript/examples/: + mysql_start_galera_sync_after_dump.sh + mysql_start_slave_after_dump.sh + mysql_stop_galera_sync_before_dump.sh + mysql_stop_slave_before_dump.sh
* Thu Oct 17 2019 larsAATTlinux-schulserver.de - 2.0.3- update to 2.0.3 + remove debug output + only log, if there really exists a my.cnf file to backup + added mysqldump example in README.SUSE
* Fri Aug 16 2019 larsAATTlinux-schulserver.de - 2.0.2- update to 2.0.2: + fix quoting + new MYSQL_OPTS option for additional options passed to all invoked binaries default: MYSQL_OPTS=\'--defaults-extra-file=/root/.my.cnf\'
* Fri Aug 16 2019 larsAATTlinux-schulserver.de - 2.0.1- update to 2.0.1: + explicitely add --triggers to the option list (enabled by default) + use --single-transaction together with --quick => ensure a valid dump file which trying to get larger tables as quick as possible (by retrieving rows for a table at a time without buffering before writing it)
* Tue Jun 04 2019 larsAATTlinux-schulserver.de - 2.0.0- update to 2.0.0: + use service and timer files instead of cron for systemd distributions + use /root/backup/mysql instead of /root/backup/db as default location for backups + allow to (un-)define the executable used for compressing the resulting SQL dump files (Standard is now \'xz\')- use systemd timer/service files on newer distributions
* Fri Feb 16 2018 larsAATTlinux-schulserver.de - 1.9.4- update to 1.9.4: + latest mysql/mariadb version require \'databases\' instead of \'database\' as option
* Thu Jul 20 2017 larsAATTlinux-schulserver.de - 1.9.3- require net-tools (not installed on JeOS)
* Tue May 24 2016 larsAATTlinux-schulserver.de - 1.9.3- update to 1.9.3: + skip the \'lost+found\' \"database\" during mysqlcheck + enhance the README about restore