Sign Up
Log In
Log In
or
Sign Up
Places
All Projects
Status Monitor
Collapse sidebar
home:lrupp
mysql-backupscript
mysql-backupscript.changes
Overview
Repositories
Revisions
Requests
Users
Attributes
Meta
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
Locations
Projects
Search
Status Monitor
Help
OpenBuildService.org
Documentation
API Documentation
Code of Conduct
Contact
Support
@OBShq
Terms
openSUSE Build Service is sponsored by
The Open Build Service is an
openSUSE project
.
Sign Up
Log In
Places
Places
All Projects
Status Monitor