Added CONFIG_mysql_dump_create_event to allow backups with fewer privileges if events are not used

sixhop / AutoMySQLBackup

A fork and further development of AutoMySQLBackup from sourceforge. http://sourceforge.net/projects/automysqlbackup/

GNU General Public License v2.0

340 stars 103 forks source link

Added CONFIG_mysql_dump_create_event to allow backups with fewer privileges if events are not used #52

Closed SLiV9 closed 3 years ago

SLiV9 commented 3 years ago

Added CONFIG_mysql_dump_create_event (default 'yes') which toggles mysqldump option --events. The default behavior is unchanged.

This option allow users that do not use events (or do not wish to back them up) to backup their database without the EVENT privilege. Combined with https://github.com/sixhop/AutoMySQLBackup/pull/51 it allows for backups using only SELECT (and LOCK TABLES if CONFIG_mysql_dump_single_transaction is 'yes') and RELOAD privileges.