Reason for Site being down over the past several hours
Well I’ve looking at making the move from MySQL 5.0 to 5.1.34 for a little while now and as you may or may not know there are quite a few big changes between the two, in how the DB’s are structured. So it’s not a move that you can just do and it should be tested.
So this wasn’t my first attempt at the change as last time I couldn’t get 5.1 to work at all with my 5.0 DB’s. This time I was able to get my DB’s migrated and working on the new version, which I had installed on another machine.
So I installed both 5.0 and 5.1 on my server using different ports and then migrated the DB’s over, including the one for this site as well. This work ok, but I noticed some overhead so tried running the upgrade tables etc. This caused me some issues so I uninstalled 5.1 or so I thought the installer actually uninstalled my 5.0 version instead.
This left me with no working MySQL installed and then when trying to get the 5.0 re-installed it just would install and work correctly. Eventually after some Googling I found my answer as there is sometime a bug in the installer which doesn’t pass the password details on.
So I am back to 5.0 for now, 5.1 is suppose to be faster and has many new great features but for now I’ll stay with the older version, which is still being used by most.