Warning: Skipping the data of table mysql.event.

September 3, 2013 — 1 Comment

Your MySQL script was running great, but then you started getting errors – If you get this warning when dumping the mysql database, it’s not a bug – MySQL did this on purpose because they wanted people to know that they weren’t dumping the event table. Previous versions did not give the warning.

Do you care about the mysql.event table? It’s for scheduled events (introduced in 5.1.6). More information about it can be found on the MySQL Event Scheduler page.

If you DO want to dump it, change:

to:

If you DON’T want to dump it, change:

to:

Trackbacks and Pingbacks:

  1. Warning: Skipping the data of table mysql.event. | Linux News ProLinux News Pro - October 31, 2013

    […] post Warning: Skipping the data of table mysql.event. appeared first on Linux […]

Leave a Reply