— 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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s