Hide Forgot
Description of problem: Since upgrade from 5.5.29 to 5.5.30 package version all our mysqldump scripts emits a warning "Warning: Skipping the data of table mysql.event. Specify the --events option explicitly." We tried using --ignore-table=mysql.event as per documentation but it still gives the same warning. Version-Release number of selected component (if applicable): mysql-5.5.30-1.fc18.i686 How reproducible: Always Steps to Reproduce: 1. Run "mysqldump --all-databases > temp.sql" or "mysqldump --all-databases --ignore-table=mysql.event > temp.sql" Actual results: Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. Expected results: The mysqldump command should not emit warnings if I use ignore-table options. Additional info: The bug appeared after changes in upstream http://bugs.mysql.com/bug.php?id=55587
Well, I'm testing that on mysql-5.5.30-1.fc18.x86_64 and the warning is printed in case --ignore-table is not used, but I don't see any warning when --ignore-table=mysql.event is used. So basically it works as expected for me. Could you share your options in my.cnf?
All our mysqldump scripts are run by cron. Seems that I had to restart crond after correcting the scripts for some reason. Now it works. Closing.