开发者

Mysql Data copy

开发者 https://www.devze.com 2022-12-18 05:52 出处:网络
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 e开发者_开发问答xcept Events.Copy th

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 e开发者_开发问答xcept Events.


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.


You can use mysqldump with the --events option

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号