mysqldatabasedumpmysql-eventdatabase-dump

dump.sql contanins also events


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.


Solution

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

    Or, in MySQL Administrator:

    dump events