File mysql-backupscript.changes of Package mysql-backupscript
-------------------------------------------------------------------
Sun Sep 10 15:31:15 UTC 2023 - Georg Pfuetzenreuter <georg.pfuetzenreuter@suse.com>
- Switch to MariaDB tooling
-------------------------------------------------------------------
Thu Dec 9 13:18:11 UTC 2021 - Lars Vogdt <lars@linux-schulserver.de>
- add explicit --databases "db" to the mysqldump line
-------------------------------------------------------------------
Wed Nov 10 11:30:43 UTC 2021 - Lars Vogdt <lars@linux-schulserver.de>
- 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 10:36:20 UTC 2021 - Lars Vogdt <lars@linux-schulserver.de>
- 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 01:50:25 CET 2021 - ro@suse.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 6 08:30:08 UTC 2020 - lars@linux-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 09:23:22 UTC 2020 - lars@linux-schulserver.de - 2.0.6
- switch to Productivity/Archiving/Backup RPM group
-------------------------------------------------------------------
Fri Feb 14 14:32:46 UTC 2020 - lars@linux-schulserver.de - 2.0.6
- use utf8mb4 as default character set
- include stored routines
-------------------------------------------------------------------
Tue Jan 7 09:29:00 UTC 2020 - lars@linux-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 1 03:22:06 UTC 2020 - lars@linux-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 10:05:51 UTC 2019 - lars@linux-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 15:12:48 UTC 2019 - lars@linux-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 12:58:22 UTC 2019 - lars@linux-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 4 08:20:20 UTC 2019 - lars@linux-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 15:06:47 UTC 2018 - lars@linux-schulserver.de - 1.9.4
- update to 1.9.4:
+ latest mysql/mariadb version require 'databases' instead of
'database' as option
-------------------------------------------------------------------
Thu Jul 20 05:33:59 UTC 2017 - lars@linux-schulserver.de - 1.9.3
- require net-tools (not installed on JeOS)
-------------------------------------------------------------------
Tue May 24 18:53:18 UTC 2016 - lars@linux-schulserver.de - 1.9.3
- update to 1.9.3:
+ skip the 'lost+found' "database" during mysqlcheck
+ enhance the README about restore
-------------------------------------------------------------------
Mon Apr 21 05:20:57 UTC 2014 - lars@linux-schulserver.de - 1.9.2
- update to 1.9.2:
+ add debug option
+ do not backup performance_schema table
-------------------------------------------------------------------
Fri Mar 21 15:58:36 UTC 2014 - mrueckert@suse.de - 1.7
- rename README file to plain README so we can use sources directly
from github
- added LICENSE file and move the license to BSD3c
-------------------------------------------------------------------
Mon Oct 14 20:59:29 UTC 2013 - lars@linux-schulserver.de - 1.7
- fix tail option (-n +2 instead of +2)
-------------------------------------------------------------------
Tue Aug 13 19:22:36 UTC 2013 - lars@linux-schulserver.de - 1.7
- remove --analyse option from mysqlcheck as this is now mutually
exclusive on younger mysql versions
-------------------------------------------------------------------
Sat May 4 23:27:51 UTC 2013 - lars@linux-schulserver.de - 1.7
- added CREATE_BACKUPDIR option in sysconfig file
-------------------------------------------------------------------
Fri Jan 14 07:58:29 UTC 2011 - lars@linux-schulserver.de - 1.7
- do not forget errors from former commands
- also flush the cache, if optimizing is enabled
-------------------------------------------------------------------
Sat Sep 4 11:51:21 UTC 2010 - lars@linux-schulserver.de - 1.7
- update to 1.7
* better quoting in drop and create statements
-------------------------------------------------------------------
Mon May 30 10:29:46 UTC 2010 - lars@linux-schulserver.de - 1.6
- update to 1.6:
* added help to cronjob script, so people can get informations
easier
+ mysqladmin does not exit with the right error code in case of
authentication problems - check for failure message instead
+ use variables for binaries and allow to define a separate
config file for testing/porting
+ quote database names in drop and create statements
-------------------------------------------------------------------
Sat Feb 27 10:29:46 UTC 2010 - lars@linux-schulserver.de - 1.5
- update to 1.5:
+ allow automatic repair/optimization after the backup
(default is 'no')
-------------------------------------------------------------------
Sat Oct 31 00:02:39 CET 2009 - lars@linux-schulserver.de - 1.4
- just be a bit more silent during find
-------------------------------------------------------------------
Fri Oct 30 20:20:19 CET 2009 - lars@linux-schulserver.de - 1.4
- use trap to delete tmpfile
-------------------------------------------------------------------
Wed Oct 28 23:21:25 CET 2009 - lars@linux-schulserver.de - 1.4
- update to 1.4:
+ cleanup backup directory by retention time (see sysconfig)
+ added test_mysql_alive to avoid errors if mysql is not running
-------------------------------------------------------------------
Fri Aug 28 15:56:38 CEST 2009 - lars@linux-schulserver.de - 1.3
- fix fallback email
- run flush logs before backup
- also safe my.cnf
- added README.SuSE
-------------------------------------------------------------------
Fri Jun 19 17:16:15 CEST 2009 - lrupp@suse.de - 1.2
- cleanup TMPFILE on clean exit
-------------------------------------------------------------------
Tue Jun 9 10:37:59 CEST 2009 - lrupp@suse.de - 1.1
- remove debug output
-------------------------------------------------------------------
Mon Jun 8 15:28:36 CEST 2009 - lrupp@suse.de - 1.1
- added LOGFILE option to sysconfig
- better error handling
-------------------------------------------------------------------
Wed May 6 18:19:39 CEST 2009 - lrupp@suse.de - 1.0
- initial version
