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
Subject
Views
Written By
Posted
migrate databases from 5.5 to 5.6 locally on Windows
1325
December 07, 2016 04:27AM
736
December 07, 2016 12:09PM
645
December 15, 2016 04:12AM
620
December 15, 2016 09:45AM
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.