Activities

August 2013
M T W T F S S
« Jul   Sep »
 1234
567891011
12131415161718
19202122232425
262728293031  

Warning: Skipping the data of table mysql.event.

You may get this warning when you take full MySQL server backup on above MySQL 5.2 GA version.This warnings cab be ignored since it is related to MySQL new feature “Event Scheduler”.

Solution : You may simply add parameter “–ignore-table=mysql.event” along with MySQL Dump command.

Eg:

 mysqldump --all-databases -r alldb.sql --ignore-table=mysql.event

Or you may add the following lines in MySQL config (/etc/my.cnf). file but it requires a service restart. So I do not recommend.

[mysqldump]
ignore-table=mysql.events

So simple ..

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>