Does Zmanda support backup Event Scheduler?

Question

I've been digging up the Zmanda Wiki, but cannot find out any option to backup the event scheduler (--events, -E).

Does Zmanda support it?

Answer 1

Yes, you have to do it in logical backup mode and add that option to the --extra-mysqldump-options:

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

backup-mode=logical
replication=1
all-databases=1
exclude-pattern="performance_schema"
ssh-user="mysql"
host="1.2.3.4"
port="3306"
mysql-binlog-path=/data/var/log/mysql
routines=1
single-transaction=never
extra-mysqldump-options="--lock-all-tables --triggers --events"
copy-plugin=/usr/share/mysql-zrm/plugins/ssh-copy.pl