Category Archives: Technical Notes

Brian’s Latest Comments doesn’t scale.

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

Posted in Technical Notes | 13 Comments

More tweaking for Ozblogistan

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

Posted in Technical Notes | Leave a comment

An nginx/PHP gotcha

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

Posted in Technical Notes | Leave a comment

Automated backups for Ozblogistan

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

Posted in Technical Notes | Leave a comment

Moving a database from WordPress to WordPress Mu

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

Posted in Technical Notes | 1 Comment