Category Archives: Technical Notes

Or, to be fair, MySQL 3.x is rubbish. But you knew that already. Most of the blogs on the Ozblogistan network use BLC. Recently, Larvatus Prodeo came on board and expected it to work for them too. But it simply … Continue reading →

I did some minor optimisations on Ozblogistan last weekend. I have HTTP compression enabled on the webserver (gzip, to be precise). I found out through the excellent YSlow plugin that not everything was being compressed. HTML was compressed, but not … Continue reading →

If you are allowing larger-than-default files to be uploaded to an nginx server with PHP FCGI, you need to alter both the php.ini and the nginx.conf. In particular, for nginx.conf, you need to use the client_max_body_size directive to set the … Continue reading →

It’s a cliche amongst nerds that everyone preaches automated backups, and very few have it. Partly because it’s surprisingly fiddly to set up “right”. And even fiddlier to do restoration testing. Still, one thing at a time. I’ve just now … Continue reading →

Some rough notes, before I forgot what I did. mysqldump –default-character-set=”latin1″ -elt database_name | sed ‘s/wp_/wp_{new blogs id}_/’ > database_name.sql –default-character-set is required because of MySQL’s unrestrained enthusiasm for fucking up encoding by assuming everything is encoded in utf8. Would … Continue reading →