MySQL Forums
Forum List  »  Install & Repo

Re: Moving DB between Windows servers with different MySQL versions
Posted by: Peter Brawley
Date: September 20, 2017 06:19PM

> need to first upgrade from 5.5 to 5.6 and then to 5.7

That's correct for mysql upgrades on one server and for a data move from 5.5 server to 5.7. In the latter case, the mysql_upgrade program will already have ensured the privilege tables in the mysql database are current, but other tables may need attention from mysql_upgrade, so I would dump the 5.5 data, install 5.6 somewhere, run mysql_upgrade there, import the 5.5 data, if necessary run mysql_upgrade again, ensure everything is working correctly, touching up as required, then dump the data and import that data into the 5.7 installation, running mysql_upgrade again in case non-priv tables need touching up.

Options: ReplyQuote


Subject
Written By
Posted
Re: Moving DB between Windows servers with different MySQL versions
September 20, 2017 06:19PM


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.