I use uniformserver - a wamp package for my local developing. It is designed like most to be portable so you can run it from a thumb drive etc.
Yesterday I uninstalled the services and copied the directory off to my external drive so I could reinstall windows.
Today I've copied it all back, installed the apache and mysql services and got back on with something for someone else.
I've been hitting glitch after glitch from nowhere for no apparent reason. Anyway eventually I've gone in via phpmyadmin and found that my primary keys have all gone along with the auto_increment setting on most tables. Not one, not two or every four or five but almost every single table (a few have survived). I have around 180 tables spread over two or three databases.
Do any of the mysql master gurus here know of any mysql magic to find out what has happened or how to undo this or am I stuck with a long hard session via phpmyadmin reinstating it all manually?