MySQL Forums
Forum List  »  Install & Repo

Moving DB between Windows servers with different MySQL versions
Posted by: Don Giddens
Date: September 20, 2017 04:27PM

I have an existing MySQL v5.5.29 database that I need to move to MySQL 5.7.18. I reviewed several posts stating that I would need to first upgrade from 5.5 to 5.6 and then to 5.7. My assumption after reading them is they are referring to upgrading MySQL on the same server. This is not my scenario. I have a new server with a fresh install of v5.7.18 and I need to take the v5.5.19 database from the old server and import it on the new server running v5.7.18.

In this scenario, can I export the data as a SQL Dump from the old server and then simply import onto the new server without the v5.6 install in between? I am not looking to move the system DB's from one version to the other, just a DB that I created.

If so, would I be able to reverse the process and go back from the new server to the old server if I find issues?

Note: Both servers are running Windows Server 2012.

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Moving DB between Windows servers with different MySQL versions
September 20, 2017 04: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.