MySQL upgrade from 5.6 to 5.7

Question

I am new to MySQL and learn fast. I installed WAMP on my system and used it for a month or so. I want to upgrade MySQL to 5.7 since I will need new gis features, but I cannot easily find step by step what I need to do.

I read in MySQL about how this is done, but found that it is confused or incomplete, but not sure what. I have been reading the last 6 hours and still do not know how to do it.

I created backups of my databases, which in fact do not interest me, since they are still in a state of development and training and will be rebuilt anyway.

How to upgrade from 5.6 to 5.7 with full instructions?

Answer 1

• Download the zip version of mysql that you want to run (not the msi installer, just because I don’t know what it can do or guess when it will be installed) Suggested source [www.mysql.com]

• From the wamp manager, stop all services.

• Go to c: \ wamp \ bin \ mysql \ and create a new folder called ie mysql5.5.28

• Unzip mysql and copy the contents of the MySQL folder to the newly created folder. Make sure the directory levels match the existing MySQL folder.

• Copy the entire contents of your previous mysql \ mysql5.5.10 \ data folder to the new data folder in your new version folder. These are ALL, not just your databases, including ibdata1, ib_logfile0, ib_logfile1 and all mysql-bin.0000xx files. We will use the recommended mysql update tool to make this normal. It also ensures that you retain all your users and password and grant rights unchanged after the update is completed.

• Copy c: \ wamp \ bin \ mysql \ mysql5.5.10 \ wampserver.conf to c: \ wamp \ bin \ mysql \ mysql5.5.28 \ wampserver.conf All folders here are relative to where this file lives, so usually nothing here need to change.

• RIGHT CLICK wampmanager → update This will force the Wamp manager to find a new version. Check this by left-clicking wampmanager -> MySQL -> Versions. Your new version should be available on the list.

• From wamp manager -> MySQL -> Version, click on your new version. Typically, you will have to remove the old wampmysql service and reinstall the new wampmysql service, but wamp will take care of all this by simply clicking on the new version number. This should also start the new mysql service, so now the new mysql is started. BUT SHOULD NOT BE ANYTHING!

• Launch a command window (using "Run as administrator"). CD to the folder c: \ wamp \ bin \ mysql \ mysql5.5.28 \ bin (folder with new versions of bin). And run mysql_upgrade -u [your admin user password] -p> upgrade_results.txt

It will ask you to enter the password for the admin user that you provided with the -u option. enter password.

Wait for it to start. If you have very large databases, this may take some time, but usually it will take from a few seconds to a minute or two. This will look at your databases and make any updates that are needed, as well as any updates / maintenace of the mysql database that MySQL uses internally. These are tables containing your user IDs and password and privileges and other things.

10. Check for errors in upgrade_results.txt file, correct if there are any. You can repeat this as often as you like, just update the data from the data folder of the old versions every time.

11. LEFT Click the wamp manager -> MySQL -> Tools -> Stop service. Then again and Start Service. This will load the modified mysql database with any new / changed configuration information.

12. At this point, assuming you are staying on a recently installed version of MySQL, there is a good idea: wampmanager -> MySQL -> MySQL Console and run

    reset master;

The reset log files.

from here: http://forum.wampserver.com/read.php?2,111797,124054