Revisions of mysql-backupscript

Lars Vogdt's avatar Lars Vogdt (lrupp) accepted request 1110152 from Georg Pfuetzenreuter's avatar 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's avatar Lars Vogdt (lrupp) committed (revision 50)
- add explicit --databases "db" to the mysqldump line
Lars Vogdt's avatar Lars Vogdt (lrupp) committed (revision 49)
fix missing '>'
Lars Vogdt's avatar 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's avatar 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's avatar Lars Vogdt (lrupp) accepted request 872757 from Ruediger Oertel's avatar 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's avatar 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's avatar Lars Vogdt (lrupp) committed (revision 44)
- switch to Productivity/Archiving/Backup RPM group
Lars Vogdt's avatar Lars Vogdt (lrupp) committed (revision 43)
- use utf8mb4 as default character set
- include stored routines
Lars Vogdt's avatar 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's avatar 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's avatar 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's avatar 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's avatar 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's avatar Lars Vogdt (lrupp) committed (revision 37)
own _fillupdir only between SLE-11-SP5 and SLE-12-SP3
Lars Vogdt's avatar 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's avatar Lars Vogdt (lrupp) committed (revision 35)
Lars Vogdt's avatar Lars Vogdt (lrupp) committed (revision 34)
create the directory, if it does not exist
Lars Vogdt's avatar Lars Vogdt (lrupp) committed (revision 33)
define/use _fillupdir
Lars Vogdt's avatar Lars Vogdt (lrupp) committed (revision 32)
define/use fillupdir
Displaying revisions 1 - 20 of 51
openSUSE Build Service is sponsored by