MySQL Forums
Forum List  »  Other Migration

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

Hello,
My CentOS 6 server 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.
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
42
June 02, 2023 08:27PM


Sorry, only registered users may post in this forum.

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.