Blog

find /var/log/hostdb/* -type d -mtime +90 -exec rm -rf {} ; -type d only look at directories, f would be files -mtime +90 modified time greater than 90 days ago

Import key into apt

14 January 2010
wget -q http://tools.hursley.ibm.com/repo/pubkey -O- | sudo apt-key add -
load data local infile 'export.csv' into table table_name fields terminated by ',' enclosed by '"' lines terminated by 'n' (field_list)

Abii monster

27 November 2009
Abi drew me this monster: Her name is A-b-i-i and she is 5. She is mad because she is sick.

My graze snacks arrived!

27 November 2009
My graze box arrived just before lunch and looked fantastic. I’ve had the pineapple and that was delicious and very juicy - looking forward to eating the rest of the box later! If you want to try it for yourself, you can get your first box free.

700 chocolate bars

18 November 2009
My entry for “The Art of Green and Blacks” - a picture made from 700 chocolate bars

What defines you?

4 November 2009
Blessed is the man
, who walks not in the counsel of the wicked, nor stands in the way of sinners, nor sits in the seat of scoffers; but his delight is in the law of the Lord, and on his law he meditates day and night. Psalm 1:1-2 (ESV) To be blessed is to know God’s favour and experience true happiness. This blessing comes from taking counsel from God rather than from those who have rejected his counsel, the wicked.

Useful SQL

15 October 2009
update [table_name] set [field_name] = replace([field_name], ‘[string_to_find]’, ‘[string_to_replace]’); Replace within a field
For our Momentum men’s events we have a Google Calendar that we use to manage the upcoming events, and this gets pulled into our website using the Wordpress plugin ICSCalendar. Recently I set up a twitter account as well, and decided that it would be useful to provide reminders of events on there, which people could then follow and receive SMS updates for. Initially I had a look around to see what I could find, and came across Calendar Tweet, but that didn’t do quite what I was looking for.