MYSQL-ZRM.CONF(5)

πŸ“¦ version 3.0, in epel 9, fedora 43, fedora 44

🌸 mysql-zrm.conf β€” the config file for ZRM for MySQL (manual section 5) 🌸

okay so bestie, gather round, because this little file is literally the main character of your whole backup setup πŸ’–


πŸ’… NAME πŸ’…

mysql-zrm.conf β€” the configuration file for ZRM for MySQL. periodt.


✨ SYNOPSIS ✨

/etc/mysql-zrm/mysql-zrm.conf

/etc/mysql-zrm/backup_set_name/mysql-zrm.conf

πŸ¦‹ DESCRIPTION πŸ¦‹

So mysql-zrm.conf is where all the site-wide (or backup-set specific, if you're feeling fancy) parameters live β€” the ones that control how the whole ZRM for MySQL suite operates. it's giving control room energy fr fr πŸ‘‘

Wanna give a particular backup set its own custom vibe? You do that by writing those parameters in a mysql-zrm.conf file that lives inside a /etc/mysql-zrm/backup set name/ directory. Or you can pass --options conf_file on most of the command line utilities. Either way works πŸ’…

Here's the hierarchy tea: parameters (and --options) that you specify on the command line override both the site-wide and the backup-set specific parameters. command line wins, no cap.

also lowkey important: if certain parameters are not specified in the the site-wide mysql-zrm.conf file, the ZRM for MySQL suite can also use the MySQL options file (my.cnf) parameters. she's flexible like that 🧚

πŸŽ€ SYNTAX πŸŽ€

This section is all about how you actually write stuff in mysql-zrm.conf. Every single parameter goes like this:

<parameter>=<value>

All parameters are optional β€” if you don't specify one, an appropriate 'factory default' just slides in. iconic behavior ✨

All white space is ignored unless it's quoted. And every line starting with # is a comment, meaning it gets ignored. so go ahead and leave yourself little love notes, nobody's reading them πŸ™ˆ

Parameters can be:

  • Backup parameters β€” comment, backup-level, backup-mode, lvm-snapshot, destination, retention-policy, replication, compress, compress-plugin, encrypt, encrypt-plugin, decrypt-option
  • Database parameters β€” all-databases, databases, tables, database
  • MySQL server parameters β€” user, password, host, port, socket, ssl-options, mysql-binpath, mysql-binlogpath, tmpdir
  • ZRM parameters β€” verbose, mailto, html-report-directory, html-reports, webserver-url, rss-header-location
  • ZRM plugin parameters β€” copy-plugin, pre-backup-plugin, pre-backup-plugin-options, post-backup-plugin, post-backup-plugin-options, pre-scheduler-plugin, passfile, ssh-user, remote-mysql-binpath, socket-remote-port

Descriptions of the ZRM for MySQL parameters and their values are available in mysql-zrm(1) and the Zmanda Recovery Manager for MySQL manual at http://mysqlbackup.zmanda.com/ πŸ“š


🌈 FILES 🌈

  • /etc/mysql-zrm/mysql-zrm.conf β€” the global configuration file, the queen of the whole setup πŸ‘‘
  • /etc/mysql-zrm/backup set name/mysql-zrm.conf β€” configuration file ZRM for MySQL.

πŸ”₯ SEE ALSO πŸ”₯

mysql-zrm(1), mysql-zrm-backup(1), mysql-zrm-manage-backup(1), mysql-zrm-restore(1), mysql-zrm-check(1), mysql-zrm-list(1), mysql-zrm-parse-binlogs(1), mysql-zrm-purge(1), mysql-zrm-extract-backup(1), mysql-zrm-verify-backup(1), mysql-zrm-abort-backup(1), mysql-zrm-scheduler(1), mysql-zrm-reporter(1)


πŸ’œ AUTHOR πŸ’œ

Zmanda Inc. (http://www.zmanda.com)


and that's the whole page bestie, we ate πŸ’…βœ¨

signing off with love from Zmanda, Inc. β€” this is ZRM for MySQL, and you've been reading mysql-zrm.conf(5). go forth and configure responsibly 🫢🌸

πŸ“¦ where this page comes from