JLBN – Backups & Restores on WAMP

In this setup guide for WAMP, we will show you the simplest method to backup your WAMP server.

Before attempting any change, even the first time password setup, you should perform a full backup based on this setup backup guide for WAMP.

Note: Even this guide is used for Wampserver, you can apply this method on other wamp package such as Xampp, EasyPHP, so on. Just make sure to select correct file(s) in proper location(s) 😉

[Read more…]

42 thoughts on “JLBN – Backups & Restores on WAMP

  • May 15, 2011 at 8:53 pm

    Saluton Mondo!
    My version of Wampserver only loads files from ‘www’ (root) it refuses to load from any other location in wamp what do I do? Ive tried editing the Apache httpd file but to no avail.
    Someone HELP! I have a site to complete :(!

    • May 16, 2011 at 4:36 pm

      mojo706, follow these guides:

      No matter within or outside LAN access, you need to setup Access, DNS, and VH; Access for permission to connect to your Wamp PC, DNS to tie Domain(s) to your Wamp PC, and VH to host multiple Domains/Websites/IP’s and even you have only 1 Domain/IP, you should use VH to set it up w/ the site you want to show up first on top and localhost on bottom and others in middle if having more than 1 site; w/ VH, other PC’s, no matter w/i or outside LAN, can access/see websites/contents on your wamp PC. If dont have real Domain, just skip DNS guide

      To setup Access, follow this

      To setup VH, follow this

      To setup DNS, follow this

  • December 1, 2010 at 10:00 am

    Thanks for your work in creating this guide.

    I read all the posts and pasted the the line in the proper place. However, when I first open wamp (after making the MyISAM change) and look at the MySQL.log, it reads as below, with no mention of MyISAM.

    It does mention InnoDB, though, which Im not sure it should. Perhaps a post of what a “correct” log should read would help?

    In any case, I appreciate any guidance, and thank you again.


    101201 6:49:37 [Note] Plugin ‘FEDERATED’ is disabled.
    InnoDB: The first specified data file .\ibdata1 did not exist:
    InnoDB: a new database to be created!
    101201 6:49:37 InnoDB: Setting file .\ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait…
    101201 6:49:37 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file .\ib_logfile0 size to 5 MB
    InnoDB: Database physically writes the file full: wait…
    101201 6:49:38 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file .\ib_logfile1 size to 5 MB
    InnoDB: Database physically writes the file full: wait…
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    101201 6:49:38 InnoDB: Started; log sequence number 0 0
    101201 6:49:38 [Note] Event Scheduler: Loaded 0 events
    101201 6:49:38 [Note] wampmysqld: ready for connections.
    Version: ‘5.1.36-community-log’ socket: ” port: 3306 MySQL Community Server (GPL)

    • December 1, 2010 at 6:10 pm

      Bill Harris, don’t worry about it since it should auto create MyISAM DB’s from now on as long as you’ve already followed this guide recisely 😉

    • December 2, 2010 at 5:17 am


      Thank you for your prompt reply! Yes, I followed guide precisely and have never created any DB yet, so this is good to know.

      Peace 🙂

  • October 25, 2010 at 4:43 pm

    So ok.. you say to get some sync program and backup files/folders..
    is it enough to just copy and paste the wamp folder into another random folder i call backup? (and also to remember which random folder that is afterwards).

  • October 9, 2010 at 4:41 am

    I have just installed Wamp 2.0i (Apache 2.2.11, php 5.3.0, MySQL 5.1.36.
    I have no line in my.ini refering to default-storage-engine. I have two sections [wampmysqld] and [mysqld]. Which section should I add default-storage-engine=MyISAM to ?

    Many thanks

    • October 10, 2010 at 10:08 am

      Peteruk, add that line into [wampmysqld] section and restart wamp to take effect

  • May 17, 2010 at 11:33 am

    Hi JLBN

    Thank you for the guide on backing up.

    I have downloaded WampServer2.01i. It installed ‘out of the box’ as they say. However, when I went to follow your guide on backing up and looked for the line default-storage-engine’ in the mysql5.1.36\my.ini it was not there. Neither was there any permutations of it.

    I then looked further. When I look in localhost/phpmyadmin and select the engines tab it assured me that MyISAM is already the default. (MyISAM – Default engine as of MySQL 3.23 with great performance).

    I have read many of your guides and out of all the info available on the web they always seem to me to be the most clear cut and sensible. Can I please ask, very very respectfully, that you add a ‘published/updated on’ date and a reference to which versions of the particular software you are actually referring to?



    • May 17, 2010 at 6:08 pm

      Hi Alan,

      Since beginning of Wamp Server version 2, it might have a little minor change in some particular files in each version; however, our guides will work for most, if not all, versions of Wamp Server, which might include older versions 1.x

      Anyway, in this particular guide, we’ve already clearly stated as follows:

      Make the change or add this line if not found in your my.ini file:

  • March 17, 2010 at 3:50 am

    This guide just saved me a boatload of time!

    Switching mysql versions created error logging into myadmin.

    Reloaded backup and it works again!



  • March 10, 2010 at 5:56 am

    JL, you are doing such a wonderful job here. If it is worth something, you have all my respect and gratitude for all the effort you’re putting in to helping us.

    Nicosia, Cyprus

  • February 18, 2010 at 11:23 am

    I’ve been asked to upgrade a WAMP5 v1.6.6 installation to WampServer2.

    The MySQL database default storage engine as shown in the WAMP5 my.ini is INNODB.

    I guess this means its now too late for me to change it to MyISAM?

    • February 18, 2010 at 6:14 pm

      wamp user, use phpmyadmin to export that DB, then uninstall wamp, rename wamp folder, restart pc, install new wamp then use phpmyadmin to import that DB. For more safety, after exporting that DB, install new wamp on different pc and try to import that DB to make sure it works as expected before actually performing upgrade on current wamp pc

  • December 31, 2009 at 10:03 am

    Before I found your website I installed wamp and attempted to create a user root password but through the mysql console.

    I messed it up so I used system restore and deleted the c:/WAMP folder and looked for registry files but couldn’t find any.

    Since I am only using localhost for learning PHP I don’t really care about a password and it seems to be a big headache. I decided when I reconfigured it I wouldn’t use one BUT

    When I log into the Mysql console it says
    Enter Password: (which I don’t have) and I can go no further.

    I have restored several times but nothing seems to give me a fresh start with NO PASSWORD.

    Please help me I don’t know what else to do


    • January 4, 2010 at 7:13 pm

      kathy, to login by default is user “root” and no password, so just press Enter if using MySQL console through wamp tray icon; however, we suggest you to follow our very easy step-by-step password guide since you never know someone someday might accidentally mess up your well-established database(s) and it’s NOT simple at all to fix that
      to setup password, follow this

  • August 2, 2009 at 8:58 am

    Hi there,

    Under Backup what does the following mean?

    Note: Make sure to switch the database type BEFORE create the database or you will lose the database after switching.

    After you’ve finsished installing and checking to make sure WAMP’s all services running, you should immediately backup your WAMP server as follows:

    • August 2, 2009 at 10:13 am

      Exactly as it meant, we recommend you to switch the database type right after installing wamp and before creating any new database because if you’ve already created any new database which is most likely InnoDB type and you will lose access to them after switching to MyISAM

  • June 29, 2009 at 3:30 am

    My system crashed, and i have to restore from files only. But before the crash i didnt change the default to myIsam

    Any suggestions how i can recover?

    Thanks in advance.

    • June 29, 2009 at 11:09 am

      Gadensgaard, did you try to copy db folder into data folder in mysql folder?

  • June 19, 2009 at 5:32 pm

    the file my.ini does not exist in the latest release of wamp as directed by this guide…
    Have you heard this problem before?

    • June 19, 2009 at 6:05 pm

      JW, make sure you already disable “Hide known extension…” in folder property or else, you only see the file “my” instead “my.ini”

  • March 26, 2009 at 6:11 pm

    First time I see an engineer providing such crystal clear explanations.

    I’ll follow the other ones, once my site is full operative, i’ll donate sthg for your contribution, promised.


  • February 6, 2009 at 2:17 pm

    That is how I ended up here. I just want to double check that I should delete the MIXED INNODB:INNODB part and just leave the MYISAM

    confirmation is all I am looking for since mine already had MYISAM in it at the end…thanks

    • February 9, 2009 at 12:32 am

      default is mixed type and that’s the problem for some people since it’s not friendly copy and paste database folder(s) for backup and restore, and that’s why we suggest to use only MyISAM type. Just uncomment that line and add suggested line 😉

  • February 5, 2009 at 8:32 am

    the rest of my line is not correct…it won’t show…

    so here it is with some marks deleted


  • February 5, 2009 at 8:27 am

    I am running mysql 5.1.30 my line says


    I am a noob at everything! can I just delete so it looks like this?


  • January 30, 2009 at 3:02 pm

    my.ini does not contain the line: default-storage-engine=INNODB

    I am running MySQL 5.1.30.

    my.ini does have the following:

    myisam_sort_buffer_size = 8M

    key_buffer = 20M
    sort_buffer_size = 20M
    read_buffer = 2M
    write_buffer = 2M

    So, I surmise all is well. Right?

    • January 31, 2009 at 7:47 pm

      just add this line to the file 😉

  • May 26, 2008 at 8:36 am

    A newbie so your guides are a tremendous help, very grateful and many thanks.
    One suggestion for people starting out like me:
    On your Setup Backup guide, it says change the default storage engine to MyISAM without explaining how. It would be helpful to state how.
    From the forums, it explains how to amend the my.ini file to default-storage-engine=MyISAM

Leave a Reply