You'll Thank Me Later
Posted by Ceri Davies Tue, 20 Sep 2005 20:02:00 GMT
I’ve decided to move the web log to Typo, purely so that I can stop running MySQL (because it keeps spinning on EAGAIN on some pipe or other), the worst excuse for a database I ever came across.
The process of doing so has only confirmed that I am doing the right thing; for example, you’d think that the --compatible=postgresql or even the --compatible=ansi options to mysqldump would produce SQL that PostgreSQL would understand. No. All that does is leave out the MySQL-specific storage clauses and quote things with with real quotes rather than backticks. The data types are not converted into something that PostgreSQL understands.
For example, PostgreSQL doesn’t understand int(n) as a datatype; integer is what it wants to see. --compatible=postgresql doesn’t know that for some reason. I count that as pretty basic.
Anyway, the point is that for now, all the articles have not been moved. They will be, I just have to work out the best way of doing it. For now, old web log is at http://submonkey.net/wordpress/ and the new one is at http://typo.submonkey.net/.
The gardening news is that I finally got hold of the site supervisor and I’ll be picking my new plot next Wednesday.
Update, 20/09, 22:48: Turned out to be easier to migrate all the posts by hand. Some comments were lost but I’m not bothered.
Um, the wordpress one redirects to typo? That's a good thing though.
Yeah, it does now :)