Convert CentOS to Oracle Linux -Mysql instance

[devindya18]

Hello,

I have a Mysql-community instance on a server currently CentOS 8 and I want to convert it to Oracle Linux 8.
Do I need to remove the repositories of mysql-community?

Thank you in advance for your reply.

Best regards,
Devin

[Djelibeybi]

If it's MySQL 8.0, I recommend disabling the repo, migrating to Oracle Linux 8 and then installing the mysql-release-el8 RPM to enable the MySQL 8.0 repo from yum.oracle.com.

If it's a different version, then it should be fine. Backup first, though!

[devindya18]

Thank you for your reply Djelibeybi .

[devindya18]

I use proxysql as load balancer. However after running the centOS2OL script I lose all the data in proxysql.
How can I recover the data ?
Thank you in advance for your reply.

[Djelibeybi]

Unfortunately, I'm not familiar with ProxySQL so the best advice would be to restore that data from the backup you made before you migrated to Oracle Linux.

[devindya18]

Proxysql uses sqlite database.Does the CentOS2OL script change something for SQLlite?
I have to document the root cause

[Djelibeybi]

You would have to review all the packages that were updated between the CentOS system and Oracle Linux. The SQLite library and binaries may have been updated during that process, as they are part of the OS. We do mention that custom things like this should be backed up and restored after migration.