HowTo: Install a new version of MySQL into wamp and migrate your data properly.


Please read the whole post before starting this process. Mistakes can cause untold hassle.

Also take a copy of your WHOLE C:\WAMP folder so you can replace it if necessary if something goes wrong.

A backup of your databases is also a good idea.


Assumption: That you are using the default wamp config where all your databses are stored in the mysql.x.y.x\data\ folder.
If thats the case no backup of your databases is necessary, but it would not hurt, just in case.
This should also work if you are using innodb databases, stored in the mysql.x.y.x\data\ folder.


This will take your complete MySQL environment, including users, passwords and privilages so they do not need to be re-created on the new release.


I have tried to keep it simple here using c:\wamp, but you may have wamp on another drive, just change c: to whatever you use.

Before you start read the upgrade notes on the mysql.com site for information on anything you may have to do to your existing data before you start the upgrade.
There should be a page devoted to major upgrades, you will have to read between the lines if you are doing a minor upgrade.

A glance at the changelog is also a good idea as it will give you a clue as to what has changed and how that may effect your SQL and or data.


So here is the process:

1. Download the ZIP version of the mysql you want to run ( not the msi installer, only because I dont know what it may do or assume when it installs )
Suggested source [www.mysql.com]

2. From wamp manager, Stop all services.

3. Go to c:\wamp\bin\mysql\ and create a new folder named appropriately i.e mysql5.5.28

4. Unzip the mysql and copy the contents of the MySQL folder into your newly created folder. Make sure the directory levels are the same as your existing MySQL folder.

5. Copy all the contents of your previous mysql\mysql5.5.10\data folder into the new data folder under your newly created version folder.
Thats EVERYTHING not just your databases, including the ibdata1, ib_logfile0, ib_logfile1 and all the mysql-bin.0000xx files.
We are going to use the recommended mysql-upgrade tool so this is ok to do.
This will also ensure that you keep all your Users and password and granted privilages intact when the upgrade is complete.

6. Copy c:\wamp\bin\mysql\mysql5.5.10\wampserver.conf to c:\wamp\bin\mysql\mysql5.5.28\wampserver.conf
All the folders in here are relative to where this file lives, so normally nothing need changing in here.

7. RIGHT CLICK wampmanager -> refresh
This will make wamp manager find your new version.
Check this by Left click wampmanager -> MySQL -> Versions Your new version should be available in the list.

8. From wamp manager -> MySQL -> Version click on your new version.
Normally you would have to uninstall the old wampmysql service and re-install the new wampmysql service, but wamp takes care of all that for you by just clicking the new version number.
This should also start the new mysql service, so now the new mysql is running.
BUT DONT DO ANYTHING YET!!!

9. Launch a command window ( using Run As Administrator ).
CD into c:\wamp\bin\mysql\mysql5.5.28\bin folder ( the new releases bin folder ).
And run
mysql_upgrade -u[your MySQL admin userid] -p > upgrade_results.txt

It will ask you for the password for the admin user you provided on the -u parameter.
enter the password.

Wait while it runs, If you have very large databases this may take some time but normally it will take anything from a few seconds to a minute or two.
This will look at your databases and do any upgrades that are required and also any upgrades/maintenace of the mysql database that MySQL uses internally.
Thats the tables that contain your userids and password and privilages and other things.

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

11. LEFT Click wamp manager -> MySQL -> Service -> Stop Service.
Then again and Start Service. This will load the changed mysql database with any new/changed config info.

12. At this point assuming you are staying on the newly installed version of MySQL its a good idea to run:
wampmanager -> MySQL -> MySQL Console
and run a
> reset master;

To reset the log files.

Source: http://forum.wampserver.com/read.php?2,111797,111797

Nice Tutorial.

Hmmmm

must I comment? lol

happy christmass to u all

hmmm.

@op Can u help install DHIS 2 server version?

.

@Op,
How do install wamp server or php, sql & apache web server on Windows 8.
I have tried several means but not working.
Any useful contributions will gtrstly appreciated.

@Op,
How do install wamp server or php, sql & apache web server on Windows 8.
I have tried several means but not working.
Any useful contributions will greatly appreciated.

Make i just dey fp ma broda....which one be wamp.....na jombo

just passin, lookin if my xcape xmas chicken is here

GodpassU: Make i just dey fp ma broda....which one be wamp.....na jombo

So u dont know wamp
Make i follow i stay for fp

GodpassU: Make i just dey fp ma broda....which one be wamp.....na jombo

So u dont know wamp
Make i follow u stay for fp

Nice tuts

The best way to upgrade wamp is to start using xamp. Period!

do you mean swamp abi swam or maybe shawarma

bory09: do you mean swamp abi swam or maybe shawarma

Wamp is a local host or server is fully mean "Window, Apach, Mysql, Php" (WAMP)

Wamp or Xamp? Just asking, never heard of Wamp. Nice Article.

maryjames9: Wamp or Xamp? Just asking, never heard of Wamp. Nice Article.

Both do dsame work broda its all Local server and both confilct wit prt80 eg if u av skype instal on ur pc u cnt install wamp or Xamp or any local server until u uninstall it

Help! Help! ! Help !!!!!!!!
Help me NL dis Is my xmas chicken ............ Chaiiioiii I'm finished !!!!!!!!

Lastdon02:
Both do dsame work broda its all Local server and both confilct wit prt80 eg if u av skype instal on ur pc u cnt install wamp or Xamp or any local server until u uninstall it

Please tell me more,i'm ready to learn.

Lastdon02:
Both do dsame work broda its all Local server and both confilct wit prt80 eg if u av skype instal on ur pc u cnt install wamp or Xamp or any local server until u uninstall it

taaa dis one na lie , I'm using both skype and xamp on the same lapi.......pack wella

cool_akins: @Op,
How do install wamp server or php, sql & apache web server on Windows 8.
I have tried several means but not working.
Any useful contributions will gtrstly appreciated.

av installed it on windows 7....i dnt think the method of installation on windows8 should differ.....wat version are u trying to install?....before u try install wamp server on ur system ensure u av Microsoft visual C++ 2010 runtime library installed on ur system or else wamp server won't work

Lastdon02:
Both do dsame work broda its all Local server and both confilct wit prt80 eg if u av skype instal on ur pc u cnt install wamp or Xamp or any local server until u uninstall it

no dats nt ryt...port conflicts do happen but can be corrected....skype or iis or Norton antivirus nd some oda programs will use port 80 as default port....so if u av skype or oda programs lyk dat u will av to change the port on which ur apache server will listen to....how to do dis: click on d wamp server icon go to apache under apache open the httpd.conf file nd search for listen:80 change it to listen:8080 or 5080...then save the file....note: to access ur site u will not type http://localhost....u will type http://localhost:8080....or 5080.....thank me later....whatsapp me @08185436877 for help......am willing to help any one out for free.

A

Abeg, help me post php code to link to mysql, err'code I've seen and tried do not seem to work for me

What are these pple saying?

abeg make I find apc vs pdp thread....
Dem dem, agbameta please stop viewing this thread , its not made for us.......

Lost my sister this night a day to Xmas very sad please like to tell her R.I.P thank you

lincolnj88: abeg make I find apc vs pdp thread....
Dem dem, agbameta please stop viewing this thread , its not made for us.......

Gerout of here, na for geeks like us

I've used XAMPP (former king of desktop server) for years until I tried Uniform Server. Since using Uniform Server, I got hooked. It is a powerful and lightweight server for Windows. Very simple to use and configure.

Check it out - Uniform Server