When using automysqlbackup to dump your mysql databases, you might run into the following error:
1 2 3 4 5 |
###### WARNING ###### Errors reported during AutoMySQLBackup execution.. Backup failed Error log below.. -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. |
While you can of course change the automysqlbackup script itself, to add the following line of code somewhere in the automysqlbackup script itself:
1 |
--ignore-table=mysql.events |
The option above is not upgrade proof, as your automysqlbackup script might get overwritten by the new version.
There is however an easier option to accomplisch this, and keep the settings:
Modify or Create your ~/.my.cnf and add the following lines of code to the mysqldump section:
1 2 3 |
[mysqldump] events ignore-table = mysql.events |
Hope this helps!