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

While taking backup of mysql tables there was a warning message saying that mysql.event table skipped from backup dump.



[root@tibero tibero]# mysqldump -u root -p --all-databases --single-transaction --quick --lock-tables=false --events > full-bkp-$(date +%F-%H-%M-%S).sql
Enter password:
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.

To overcome this , we have to explicitly pass the parameter –events as per the warning message

[root@tibero tibero]# mysqldump -u root -p --all-databases --single-transaction --quick --lock-tables=false --events > full-bkp-$(date +%F-%H-%M-%S).sql
Enter password:
[root@tibero tibero]# ls -lrt full-bkp-2021-07-27-14-05-55.sql
-rw-r--r-- 1 root root 527540 Jul 27 14:05 full-bkp-2021-07-27-14-05-55.sql

Leave a Reply