Revisions of mysql-backupscript
Lars Vogdt (lrupp)
accepted
request 1110152
from
Georg Pfuetzenreuter (crameleon)
(revision 51)
MySQL has been superseded by MariaDB on recent openSUSE distributions. This patch switches mysql-backupscript to use MariaDB native tooling, and resolves a warning which prevented script execution on Tumbleweed: ``` /usr/bin/mysql$tool: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb-$tool' instead. ``` Backup functionality with this patch was tested on a distribution packaged MariaDB on Tumbleweed 20230906 and Leap 15.5.
Lars Vogdt (lrupp)
committed
(revision 50)
- add explicit --databases "db" to the mysqldump line
Lars Vogdt (lrupp)
committed
(revision 49)
fix missing '>'
Lars Vogdt (lrupp)
committed
(revision 48)
- 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
Lars Vogdt (lrupp)
committed
(revision 47)
- 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.
Lars Vogdt (lrupp)
accepted
request 872757
from
Ruediger Oertel (oertel)
(revision 46)
- 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
Lars Vogdt (lrupp)
committed
(revision 45)
- update to 2.0.7: + only send out final nsca message if USE_NSCA is enabled (yes)
Lars Vogdt (lrupp)
committed
(revision 44)
- switch to Productivity/Archiving/Backup RPM group
Lars Vogdt (lrupp)
committed
(revision 43)
- use utf8mb4 as default character set - include stored routines
Lars Vogdt (lrupp)
committed
(revision 42)
- 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
Lars Vogdt (lrupp)
committed
(revision 41)
- 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
Lars Vogdt (lrupp)
committed
(revision 40)
- 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
Lars Vogdt (lrupp)
committed
(revision 39)
- 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'
Lars Vogdt (lrupp)
committed
(revision 38)
- 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)
Lars Vogdt (lrupp)
committed
(revision 37)
own _fillupdir only between SLE-11-SP5 and SLE-12-SP3
Lars Vogdt (lrupp)
committed
(revision 36)
- 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
Lars Vogdt (lrupp)
committed
(revision 35)
Lars Vogdt (lrupp)
committed
(revision 34)
create the directory, if it does not exist
Lars Vogdt (lrupp)
committed
(revision 33)
define/use _fillupdir
Lars Vogdt (lrupp)
committed
(revision 32)
define/use fillupdir
Displaying revisions 1 - 20 of 51