mysql数据库技巧

Warning: Skipping the data of table mysql.event. Specify the –events option explicitly

— Warning: Skipping the data of table mysql.event. Specify the –events option explicitly.

mysqldump -uroot -pxxxxx –all-databases > all.sql
mysql用mysqldump导出数据库时提示“– Warning: Skipping the data of table mysql.event. Specify the –events option explicitly.”

因为mysqldump默认是不备份事件表的,只有加了–events 才会解决加上–events –ignore-table=mysql.events参数即可:

mysqldump -uroot -pxxxxx –events –all-databases > all.sql

参考URL

http://bugs.mysql.com

京ICP备11047313号-21