Upgrade to MySQL 5.7

jhsim

Does anyone know of a guide or tutorial for moving a Vanilla database to a new version of MySQL?

Currently running Vanilla 2.8 on MySQL 5.5.

MySQL 5.7 is now available with my ISP, but a first attempt to simply export and import the existing sql file failed miserably.

R_J

That shouldn't be any problem. Here are two links which I would say give good advice on how to do it based on the level of access that you have to your database:

https://www.youtube.com/watch?v=ptaRO_824MU

https://dba.stackexchange.com/questions/174/how-can-i-move-a-database-from-one-server-to-another

If it still fails, try to explain "fails miserably"

jhsim

Hi R_J thanks for those links. This could take a while...

allensolly

In the following link there is a step by step procedure for upgrading the mysql...

https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html