migrate databases from 5.5 to 5.6 locally on Windows
Posted by: Michiel vM
Date: December 07, 2016 04:27AM

Hi, I was asked to upgrade an existing Mysql 5.5.34 to 5.6.33 on a Windows server.
For this I used the installer and ended up with 2 versions of MySQL server on the same machine.

I managed to "shutdown" the 5.5 version.
Now I'm left with an empty MySQL5.6 server. It shows only the default databases. Someone suggested to copy the data directory from the 5.5 dir to the 5.6 dir and run mysql_upgrade. Which I did.

When I run "show databases;" they're still not there.
What do I need to do to migrate my existing databases into 5.6??

Please help me out. I'm a relative newbie to MySQL

regards,
Michiel

Options: ReplyQuote


Subject
Views
Written By
Posted
migrate databases from 5.5 to 5.6 locally on Windows
1325
December 07, 2016 04:27AM


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.