If all went according to plan, This is me up and running with Movable Type on MySQL. It wasn’t nearly as terrifying an experience as I’d feared: run backup, run checks to make sure all libraries are in place, change configuration file to point to MySQL database, run mt-db2mysql.cgi, and then delete same to make sure I don’t accidentally re-run it.
I think I will leave the old Berkeley DB files in place for a while. Now that we’ve upgraded our web hosting account we have stacks of space anyway.
Our web host is still EZPublishing.com, but for the first time I’m not entirely happy with them. We used to have one of their “Entrepreneur” packages, which gave us everything we needed, such as a MySQL database, a subdomain, PHP, scripts anywhere, shell access, and a number of POP3 mailboxes. That package came with 100MB of file space and heaps of bandwidth. We were pushing up against the file space limit just before I went off to Boston.
Ideally, I would like to have upgraded our account with just some extra file space, but this turned out not to be possible. We had to upgrade to a “Corporate” account, which, as well as bringing our file space allowance up to 200MB, also gives us additional MySQL databases, more subdomains, more POP mailboxes, and more FTP logins. None of which we actually need.
Oh, I ‘m sure we’ll find a way to put all these extras to use (except the POP mailboxes…we really don’t need 30 of the buggers), but they’re costing us an extra $10 a month when all we wanted was some more disk space. With hard disks nowadays coming in at less than a £1 per Gigabyte, this seems kind of ridiculous. It also makes EZPublishing seem quite inflexible, and suddenly much less competitive in the hosting marketplace.
We’ve been with EZPublishing for about three years now. We know them and we trust them. With web hosting being such a commodity market these days, though, it’s inevitable that there are a lot of cowboys out there who will happily sell you a package, but run for cover when the shit starts hitting the fan. I’d be very reluctant to move to a different host without some very good recommendations, from people I trust.