I would like to migrate my Mysql databases from Ubuntu to RHEL..what is the best way to proceed? I'm on community edition. I will be moving to entreprise edition of MySql on RHEL.
5
-
Just as a matter of interest, why are you choosing MySQL Enterprise Edition? What does it offer you over the GA edition? I agree with @PhilSumner BTW.– VéraceJul 14, 2015 at 8:02
-
Well.. Just assume I'm too rich :)– tesla747Jul 14, 2015 at 8:46
-
Very funny :-). However, my question was actually serious. It appears to me from my own experience that MySQL EE customers are few and far between. I am genuinely interested as to what were the factors that have made you decide on that path. Thanks for your input!– VéraceJul 14, 2015 at 9:11
-
It has to do with licensing basically.. as an org we ought to go for EE.. there is much to risk on the compliance part.. does the GA feature has enterprise backup feature? I doubt it.– tesla747Jul 14, 2015 at 10:38
-
There's XtraBackup from Percona! :-) But, if you're redisributing, then you've no choice, unless you want to GPL your app!– VéraceJul 14, 2015 at 10:40
Add a comment
|
1 Answer
Depending on the hardware you're moving from/to (or not moving), you could just take the data & config files, and copy them across to the new system. If the new system is set up the same for storage/memory, this might just work, but may need some tweaking of config to make it happen.
If you're changing to hardware where you can't just copy the files, then your only realistic option is a mysqldump export.
