Mysql Data Problem

Question

I want to copy the whole Mysql Data including Events to newly Os installed system.is it possible to do that? Note: I have have copied the Data folder it works fine except Events.

Answer 1

You can use mysqldump with the --events option

Answer 2

Copy the data files on to another machine where you've installed the same version of MySQL as was previously used and mysqldump --events them from there. Make sure this includes the "mysql" system database. Note that it has to be the SAME version. You can throw this instance away when finished.