csammisrun

(with apologies to Will Smith / DJ Jazzy Jeff)

Now this is a story all about how
My site got twist-turned upside down
So I’d like to take a minute just sit right there
I’ll tell you how I fixed this blog ’bout a situation rare

It’s been four months or more since a topic’s been raised
Getting married is how I’ve spent most of my days
Working some, gaming, spending time with my wife
Now the wedding is done so I can write about life

Then thirty thousand bots, they were hawking their sites
Started writing comments with lots of bytes
I tried one little upgrade and WordPress got frustrated
“There’s so much junk here, now your backup’s truncated!”

I cursed MySQL for its lack of transaction
But I thought for a second and calmed down a fraction
If work’s taught me anything it’s been “save data twice”
This recent SQL dump would make everything nice

I wrote some lines of script (about seven or eight)
And it cleaned out the spam not two seconds later
Re-imported the data and now I prepare
To write posts on this blog ’bout a situation rare