October 6, 2010 – That's Geeky

WordPress database error: [Disk full (/tmp/#sql-temptable-6665-2a68327-0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (81, 85) ORDER BY t.name ASC

Time on AWS Linux AMI

The time on the Amazon Linux AMI is set, by default to UTC. To change this, symlink one of the timezone files from /usr/share/zoneinfo/ to /etc/localtime. The change takes effect immediately (and will also affect most logs, etc). For example: ln -sf /usr/share/zoneinfo/EST5EDT /etc/localtime To make the change persist through updates, it is necessary to… Continue reading Time on AWS Linux AMI

Using a SATA hard drive through IDE – Part 1

One of the older computers I have around is from before the SATA era – it only supports IDE. Unfortunately, most new hard-drives are SATA, especially those of reasonable sizes (250GB, 500GB, etc). This machine previously had only about 60GB, which was insufficient for its purposes. I find external hard-drives to be impractical for day-to-day… Continue reading Using a SATA hard drive through IDE – Part 1

M	T	W	T	F	S	S
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31