Ricky Moorhouse

2010

Delete directories older than 90 days

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

wget -q http://tools.hursley.ibm.com/repo/pubkey -O- | sudo apt-key add -

Load CSV data into MySQL

load data local infile 'export.csv' into table table_name fields terminated by ',' enclosed by '"' lines terminated by 'n' (field_list)