http://doing.nothing.net.nz doin nothin! Wed, 15 Oct 2008 01:54:16 +0000 http://backend.userland.com/rss092 en So the national library of New Zealand has decided they need an archive of all the .nz websites. You can read about it here: http://www.natlib.govt.nz/about-us/current-initiatives/web-harvest-2008 In summary, from the website, they are "harvesting": Web pages and documents on hosts that fall under the .nz top-level domain. Web pages and documents on hosts that have been ... http://doing.nothing.net.nz/national-library-of-nz-web-harvest/ (Yes, these power rails should be mounted vertically, but this rack is SHIT and won't take them) We had to order some shorter rails :( http://doing.nothing.net.nz/fail/ Throughout human history, as our species has faced the frightening, terrorizing fact that we do not know who we are, or where we are going in this ocean of chaos, it has been the authorities, the political, the religious, the educational authorities who attempted to comfort us by giving us ... http://doing.nothing.net.nz/something-else/ So I went to Kiwicon, the first proper New Zealand hacker / security conference last weekend. The talks were awesome, and i'll update some more about that when I get a chance, but part of the fun was seeing Kiwicon posters on important buildings around Wellington. Apparently the NZ Defense security team ... http://doing.nothing.net.nz/dont-fuck-with-the-government/ I get this question all the time. "How big is my mysql database?!" It's not always an easy answer, but this little bash foo seems to take care of it. mysql -uusername -ppassword database -e 'show table status;' | \ awk '{sum=sum+$7+$9;} END {print sum/1024/1024}' Gives you the database size in mb. :) http://doing.nothing.net.nz/how-to-find-the-size-of-a-mysql-database/ We've started doing some mysql db replication at work, and I found this really easy to do - for (almost) redundant instant backing up of mysql db's. So here we go: (this assumes you have root access / mysql command line access and all that) We're working on two servers, I'll call them ... http://doing.nothing.net.nz/how-to-do-mysql-db-replication/ Recently i've been doing a few site migrations, involving taking an old site and moving the site / db & everything to a new host. So, here's what I did. Firstly, I set the domain TTL's to something really low, like 300 seconds. This lets us change around NS entries quickly, without ... http://doing.nothing.net.nz/moving-or-migrating-a-website-to-a-new-server/ HOW TO HACKZ0R YOUR XBOX! I used a simple softmod to hack my xbox. My xbox was purchased in New Zealand (so its PAL based) and it is a version 1.6b. (this is not really important, this mod should work on all xboxes) BIG NASTY WARNING! This mod won't cost you anything but is a ... http://doing.nothing.net.nz/how-to-hack-an-xbox/ FINALLY we (the linux community) have flash 9. Flash 9 (beta) was released on the 18th of October, and I for one have been waiting a Loong time for this puppy. Finally, I can play line rider without having to do any stupid wine hacks - to make things work in linux. Installing ... http://doing.nothing.net.nz/flash-9-for-linux/ So I sucked it up and decided to drop Windows Vista on my work PC - I know this has typically been a Linux blog - and most of my work seems to revolve around Linux-y things, so you could say I'm just a little biased. But, anyway, here goes. My review ... http://doing.nothing.net.nz/vista/