It’s not easy to upgrade to 2.9.2 on 1and1.com. They’re using MySQL 4.0.x and 2.9.2 requires 4.1.2 and better. But they do give you access to MySQL 5.0.x you just have to migrate your existing database over to it. Manually.
I was able to find some notes on workarounds but they didn’t work as well for me due to the size of my database. I ended up having to create the new database in chunks, not difficult since I’m pretty familiar with SQL (certified by Microsoft even) but annoying. But eventually I got it all working. I think.
On the plus side I was able to do a lot of database cleanup, dropping old unused tables and optimizing existing ones so the new database is much cleaner and in theory should be a little faster. Although it’s on different hardware so it’s a crapshoot.
I also took the downtime to update the ‘captcha’ mechanism which seems to generate less obscure, aka hard to get right, human verification checks. But with 100′s to 1000′s of script based spam, primarily porn and grey market drugs, in comments a day I’m just not able to have an open comments (non admin approved before it posts) section or an easy to bypass mechanism.
Recent Comments