WampServer is a Windows web development environment. It allows you to create web applications with Apache2, PHP and a MySQL database. I found WampServer is an easy tool for development PHP app in Windows.

But since, I have to upgrade my development environment to match my production server for PHP 5.3.x and MySql 5.5.x, WampServer installer is not easy at all to do upgrading stuff for us easily.

Before I used WampServer 2.0d and now I’m going to upgrade to WampServer 2.2d which is not so different but I have already more than 20 virtual host configuration on my local machines and especially mysql databases.

http://www.wampserver.com

http://www.wampserver.com

So I take following steps to make this happen without losing any databases and has less configuration after the new installation, here are they:

  • Step 1: Backup old wamp folder, rename it to wamp1
  • Step 2: Download latest WampServer here (my case: 2.2d)
  • Step 3: Install WampServer, normally it named as: wamp (not overwrite the old installation)
  • Step 4: Test if my new installation is working by start all services and type: localhost
  • Step 5: Move my virtual host configuration from old version to the new one
    • Old: wamp1\bin\apache\apache2.2.6\conf\extra\httpd-vhosts.conf
      • And backup the new httpd-vhosts.conf of the new WampServer
    • Copy overwrite to wamp\bin\apache\Apache2.2.21\conf\extra\httpd-vhosts.conf
  • Step 6: Copy my old mysql database in folder: wamp1\bin\mysql\mysql5.0.45\data
    • All folders, except folder: mysql & test
    • Copy all database folders to: wamp\bin\mysql\mysql5.5.20\data
    • You will have all databases there but you need to recreate database users for each of your database since we don’t copy mysql folder to here
  • My case: known issues & solutions (see below)
  • Step 7: Enable virtual host in httpd.conf as normal
  • Step 8: Start all services, if any error, please have a look to wamp/logs folder
  • Step 9: You should have everything the same as your previous wamp version. You’ve done!

Known issues with WampServer2.2D in my case

Issue 1:  Error with log file size which is different from your previous config / data

InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
  • Solution: Change in wamp\bin\mysql\mysql5.5.20\my.ini
    • Before:
      #innodb_log_file_size = 5M
      #innodb_log_buffer_size = 8M
    • Change to
      innodb_log_file_size = 10M
      innodb_log_buffer_size = 18M

Issue 2: I can’t create mysql database user with mysql gui tool (MySQL Administrator)

Of course, it is the old tool (which is no longer support), it was working with my previous mysql version but mysql 5.5.x it doesn’t, we can’t give any privilege to database user.

MySQL Workbench

MySQL Workbench

  • Solution: Stop using MySQL Administrator, use MySQL Workbench 5.2.x which is supporting by Mysql community, just create one instance of Server Administration, you can do everything as before.

 

It might help you as well. Good luck.

  • really useful information, thanks 😀

  • Nero

    PLease on my Wamp server 2.2, i cant access the phpmyadmin from my newest browsers like Opera 15, Chrome, Internet Explorer 9, Mozilla Firefox 12. I only access it through Opera 11. The Error i do receive is ”

    Forbidden

    You don’t have permission to access /phpmyadmin/ on this server.”

    PLease i will be very much grateful to find help.

    Thanks in advance
    Nero

  • Hi Nero, I have never faced that as well but I found two posts said above that. Are you on Windows or Unix?

    Can you try to change: wampaliasphpmyadmin.conf :
    to allow access from all IP: Allow from all

    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
    Order Deny,Allow
    Deny from all
    Allow from 127.0.0.1

    to

    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
    Order Deny,Allow
    Allow from all

  • Nero

    Am using windows…but i have to try your option.
    Please do let me know what next since am using windows…am waiting…

    Thanks

  • Does above solution not work for you?

  • agent_rock

    Is it safe to run unins000.exe in the wamp1 folder after installing the new wampserver?