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.
MySql DB from Ubuntu to RHEL
migrationMySQLmysql-5.5redhatUbuntu
Related Question
- MySql 5.5 in ubuntu repository
- Mysql – Ubuntu / MySQL – How to choose from the various downloads
- MySQL on Ubuntu consuming almost all RAM
- MySQL – How to Migrate Schema Structure from One Server to Another
- Sql-server – Migrate data from MySQL to SQL Server, database names differ
- Mysql – copy installed thesql from ubuntu to centos7 directly without installation
Best 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.