MySQL Forums
Forum List  »  Other Migration

Need Assistance migrating MySQL Server 5.6 to 8
Posted by: Vito Cavallo
Date: June 02, 2023 08:32PM

Hello,
A CentOS 6 server I inherited was running MySQL Server 5.6.10 and the system drive died before I could migrate to MySQL 8. I have a tape backup of the mysql data folder.
I read I need to get to 5.7 before I can migrate to 8, is this correct?

I installed CentOS 7 MySQL 5.6.51 from the RPM package an updated via the yum repo file. I am guessing I need to have a working mysql in current version before I migrate higher.
I verified the path in my.conf file was pointing to the correct folder. mysqld does not start, I am getting many failures. I am thinking the 5.6.10 is a bit different than 5.6.51 and I probably need to start with the original version.

My main goal to be running Rocky Linux 8 or 9 and mysql 8.x.
Can anyone offer some high level tasks to get me to 5.7 and 8?
Am I on the correct path going up with the version numbers?
Shall I start with a new blank database and import the old databases?

Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
Need Assistance migrating MySQL Server 5.6 to 8
315
June 02, 2023 08:32PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.