Autarchy of the Private Cave

Failure Trends in a Large Disk Drive Population (or here, if that link doesn’t work)

Worth reading for any IT guy, especially for people dealing with lots of HDDs.
Also might be interesting for those, who have Gmail with (now) over 6GiB storage…

Most frequent use: convert database from latin1_swedish to utf8_general_ci.
Original script found at: MySQL and UTF-8.

Update: the original script had an error, it would generate queries likes this one (note the bold part):

ALTER TABLE `links` CHANGE `link_rel` `link_rel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT NULL;

This is clearly wrong syntax (and logic). I fixed this by making comparison to NULL strict (with three equal signs instead of two):

// Does the field default to null, a string, or nothing?
if ($row['Default'] === NULL)

Update 2: based on comment by banesto, I modified the script; now it does not require specifying the from_collation, it’s sufficient to specify to_collation (which will be used for all the fields and tables). The modified code is:

if ($row['Collation'] == ” || $row['Collation'] == $convert_to)
continue;

Update 3: the long-lasting, re-appearing NOT NULL DEFAULT NULL problem is finally fixed.

Update 4: incorporated Russ’s fix to skip numeric fields (in order to leave autoincrement values intact).

Here’s the script itself: (to copy-paste: first click the “Plain text” header)
Read the rest of this entry »

Found this one very informative: 6 steps to stop content theft.

Also: 5 content theft myths, and why they are false.

And more links:

• free internet fax
• anti-spam email 1 (recommended)
• anti-spam email 2
• create on-demand snapshot (archive) of the cited web-page

Today I moved my blog and gallery into MySQL5 databases from an elderly MySQL4. Also, both WP and gallery are now updated to the latest versions. Soon I’ll change the WP and G2 themes – for the lighter, less cluttered – and will remove some ads… and will also add some others instead

Update generally went well, except for the message I got on the main page:

Sorry, but you are looking for something that isn’t here.

It was quite easy to figure out that new WP conflicts with an elderly “Sideblog” plugin – so I had to deactivate that one, and will have to update all the active plugins to avoid some other less evident problems… (actually, just completed updating all the plugins… quite a time-eater, that was.)

Also, there will be a slight change to what and how I write. No other details for now – but stay tuned! All the changes with no exceptions are planned for the good of readers, and for the users’ benefits!

The IT Crowd is a British sitcom.
I greatly enjoyed both seasons (a total of 12 episodes).
Though somewhat and sometimes primitive, The IT Crowd is highly enjoyable and recommended for watching.

Today, using memtest86, system speed test, hddspeed and some other DOS utilities for diagnosing and testing PC hardware, I decided to put together my own simple bootable utility CD disk. But first, I did some searching to find if something similar exists.

It does exist – Ultimate boot CD. That CD has numerous freeware testing and diagnosing utilities which will help you – if you are up to some good old (read “small fast”) DOS utilities. And not that old, actually – modern hardware is supported.

The only modification I’ll do to the Ultimate boot CD will be adding freeware bin/hex viewer/editor. Surely, more utils to come – with original size of just 115MB, there’s plenty of room to add extensions. You can even extend the CD image with non-free software, like Partition Magic.

P.S. To diagnose and fix software problems – have a look at System Rescue CD.

Quite an entertaining story:
SCIgen at wikipedia
SCIgen tool
SCIgen blog

Finally, just a useful resource if you need a shiny name for your brand-new 2.0-beta project: anagram server.