Upgrade from CentOS 6

[gera]

I got a really old CentOS 6 box with cPanel 11.86.0.40. I'm installing a new box to migrate this one, running Rocky Linux 8 and cPanel 110.0.7 is already installed.

But when trying to migrate the other box, it shows two problems:

- Not being able to migrate roundcube database
- Mainly, it can "downgrade" from MySQL 5.6 to MySQL 8 (not sure about this definition of downgrade, tho).

I can maybe get around the roundcube problem, but what about the issue with MySQL? An easy way to go here?

 

[vanessa]

For roundcube, did you ever convert to sqlite? There shouldn't be a roundcube db anymore. Try:

/scripts/convert_roundcube_mysql2sqlite

For the MySQL issue, don't worry about it. Your new server will have MySQL 8 on it and you should be able to just migrate to it, but do make not of strict trans tables, which is the only gotcha I can think of. If you're coming from 5.6, you'll likely want to disable this: How do I disable STRICT_TRANS_TABLES for a Homebrew-installed MySQL server?