Home / server / Questions / 380518
Accepted
quanta
Asked: 2012-04-18 21:03:43 +0800 CST

Does Zmanda support backup Event Scheduler?

  • 772

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?

backup mysql amanda event-scheduler

1 Answers

  1. Best Answer

    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
    • 0