dump.sql contanins also events

Question

I just want to know if, when I create a backup (dump.sql) of my MySQL db, it will contains also events that I create and that perform changes in my db for example every day. The events will be stored in the database information_schema so I'm not sure that with the backup of my db I save also the events... Thanks in advance.

Answer 1

It can, but only if you include the --events option.

Or, in MySQL Administrator:

Answer 2

For example, using -E or --events, you can export the schema and data of the tables of apple database with its events to backup.sql as shown below. *My answer explains how to perfectly export databases:

mysqldump -u john -p -E apple > backup.sql

Or:

mysqldump -u john -p --events apple > backup.sql

Answer 3

From the command line , run the mysqldump command with --noevents flag

mysqldump -u username -p --events dbname > anyfilename.sql