Export only events from a MySQL database

user_1051570 0
Viewed 3926

As a part of a migration, I need to export MySQL events from a MySQL 5.6 cluster and import them in a MySQL 5.7 cluster

Is copying the table mysql.event enough for this or is there any better way to export only events from a MySQL database?

mysql-event mysql
1 Answers

I tried this:

mysqldump -A --no-data --no-create-info --skip-triggers --no-create-db \
   --events > just-events.sql

It seems to dump only events.

Bill_Karwin_208600
Related