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.
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.