WampServer

how to update from WAMP 2.0 to 2.2E?

There is no documentation and I am not sure if it will not overwrite everything I got. Will my databases still be there?

I made a backup of c:wamp
then uninstalled 2.0
installed 2.2se
copy-pasted all databases from C:\wamp\bin\mysql\mysql5.1.36\data\ to C:\wamp\bin\mysql\mysql5.5.24\data

now some databases are corupt, others seem fine.

Is there a way to fix this?
Would it be possible to make some kind of documentation for update/migration?

Try the MySQL site for how to migrate from 5.1 to 5.5. Thats quite a version jump for you to expect a straight file copy to work.

Would be better to do a backup to SQL on the old version and then a restore into the new one, using phpMyAdmin.

MySQL has no support forum or documentation about this, and I was expecting this to be a WAMP-thing, but obviously I was wrong.

I have about 30 sites local, and for the most important sites I got a sql backup from online, so I can rebuild stuff. (Not looking forward to that, PHPmyadmin can not handle the import of those big databases, so I got to use bigdump).

Some of the corrupt databases can not be deleted. This is the error I get:
#1548 - Cannot load from mysql.proc. The table is probably corrupted

oowh. I just deleted the folder of that database and that makes it not show in PHPmyadmin. Probably not the best way to do that, but works for me. *makes note for next WAMP migration*

thank you.

It's really simple.

Just open PHPMYAMDIN and EXPORT your Db into SQL format.

Then install the new wamp and import them.

Any other way has the possiblilty of causing corruption depending on the storage engine being used.

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Please remember that WAMPSERVER ( possibly the word server confuses people into assuming wamp itself is a web server, and it is not ) is just a nice handy tool for installing Apache, MySQL and PHP in a pre-configured ready to go way.

You still need to have some Apache and MySQL knowledge or read up on them yourself if you are doing anything other than just playing with it.


The MySQL website does have documentation about this, in fact it has a page specifically for upgrading from 5.1 to 5.5.
Here is a link

[dev.mysql.com]

It would be better to do a drop database from phpMyAdmin or the mysql executable to remove databases but MySQL seems to be able to cope quite well if you just delete the folder from the /data/ folder so dont panic.

sure export is no problem, but import with PHPmyadmin crashes on big databases. so I use bigdump.php, which works fine, but its just more work.

[dev.mysql.com]
thank you.
how crazy is that. If you go to
[www.mysql.com]
that extra tab 'documentation' is gone. #usability #fail

If you want to load large databases use the mysql.exe


mysql.exe -uroot -p databasename < TheSqlDumpFile.sql

thank you. will look into that.