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.

  • 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érace Jul 14 '15 at 8:02
  • Well.. Just assume I'm too rich :) – tesla747 Jul 14 '15 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érace Jul 14 '15 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. – tesla747 Jul 14 '15 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érace Jul 14 '15 at 10:40

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.