Mag-Backup Ka Ng DB (At Ibigin Mong Tunay)

I got some frantic e-mails, Plurks, and Tweets yesterday because my site went down.  Not that it changed the world or anything, but some readers just went bonkers over the thought of an “internal server error.”  Theories for downtime included bad karma (hmmm…), that I’ve been hacked (woot!), and that something crazy happened with my host (at least they’re responding to problem tickets fast).  So, what happened?

To be honest, I don’t really know, but me and Gail stayed up the whole night to see what the heck was happening.  It was like tech support meets House, since we live in completely opposite ends of the Metro.  Apparently, something messed up the databases, and considering that I’m not a very high-end user of WordPress or system resources, we arrived at the possible conclusion that I’ve been hacked.  Or maybe I’ve a larger following than I thought.  Or that I’ve been hacked.  The idea of being hacked makes me happy.

Yep, this knight in distress was saved by a damsel in shining armor.  Anyway, if you know the whereabouts of that possible hacker, this size-seven boot is possibly going out on a date with that hacker’s ass.  And oh yeah, thanks for those Plurks, Tweets, and e-mails: I never really knew how much you guys cared, even if it was just for a day of downtime.

Well, there’s no problem that couldn’t be resolved.  Now that we’re repaired everything, I’ve backed up my database (LOL, I back up once every three months, look at where it got me), and everything – hopefully – is smooth sailing from here.

So… what lessons have I learned over downtime?

  • Back Up, Back Up. Once I got a handle of my WordPress skills I started backing up WordPress manually.  Yet on that one occasion that I upgraded to WP 2.8.3 with an automatic upgrade option, some things went wrong (some things were already wrong anyway, so it wasn’t like Fritz’s problem).  It took overlooking backup just once to compound a problem into a bigger one.
  • Take Care of Databases. Every once in a while you should check databases and repair them if needed.  And oh yeah, back up your database manually.  Gail tells me this is all that stands between disease, death, and damning doom.
  • Save Soft Copies of Your Blog Posts. I used to back up copies of my blog posts in Word or Notepad or something like that, but then over the years I’ve warmed up to an “if-it’s-there-it’s-there” mentality, forgetting that the archives of what I write are quite important to people who read my blog.  So folks, if you write a lot of stuff and you know you write good, save your posts. Don’t wait for an SQL backup or anything technical; you can start by simply writing in Word, saving the file, and copy-pasting the text to your entry editor.

Anyway, I did end up downloading a lot of Gil Ofarim songs over downtime.  And Gil Ofarim freakin’ rocked.

So to put everything behind me now, let this lyrics alteration serve as a reminder to all bloggers everywhere…

Mag-Backup Ka Ng DB

From Andrew E., “Humanap Ka Ng Panget”

Ay naku kasi ano
Ang hihilig kasi sa auto-upgrade
Kinalimutan ang DB backup
O anong napala n’yo e ‘di wala
Kaya kung ako sa inyo
Makinig na lang kayo sa sasabihin ko
Mag-backup ka ng DB at ibigin mong tunay
‘Yan ang dapat mong gawin
Kaya makinig ka sa akin
And it goes a little something like this

Kung gusto mong lumigaya ang yong blogging life
Mag-backup ka ng DB at ibigin mong tunay
Isang DB na kahit na di mo matanggap
At huwag sa auto-upgrade na iyong pangarap

Ngunit kung bakit ko sinabi to’y simple lang
Pagkat kung di nagback-up ng DB parang naglalaro lang
Ng iyong oras, pagod, hirap at blog entry
Ngunit handang-handang iwanan ka naman sa sandali
Na ikaw ay wala nang ibigay, ‘di ba?
Kaya back-up lang ng DB ang gawin mo ‘day
Kung hindi, sige ka puso mo’y mabibiyak
Mawalay man ang blog mo ay hindi ka iiyak

Mag-backup ka ng DB
Mag-backup ka ng DB
Mag-backup ka ng DB
Ibigin mong tunay

Basta nag-backup ka ng DB at ulit-ulitin
Magloko man, sige lang, andiyan pa rin
Pagka’t ang iyong DB ay iyong pag-aari
Pag-isipan mong hayaan ay hindi na maaari
At kung magkamali ka man, huwag mag-alala
Sigurado kang may DB na ire-restore mo lang
Kung kasama mo siya, di bale na kaliitan
OK lang naman panigurado lang sa downtime

Kaya’t para lumigaya ang iyong blogging life
Mag-backup ka ng DB at ibigin mong tunay
At kung hindi, sige ka puso mo’y mabibiyak
Kahit Internal Server Error ay hindi ka iiyak

Sasabihin ko sa inyo kung ano ang nangyari
Nang minsan akong nagblog at di nagback-up ng DB
Mga readers ko daw ay talagang marami
Ngunit di ko napansin na may topak ang aking DB
Pagka’t sabi nila may nag-hack sakin ng sobra
Kahit di ako maniwala nangyari talaga
At ng dahil doon, gising ako buong gabi
Hanggang madaling araw ma-restore lang ang DB

Ako’y shocked
Araw-araw na nagsusulat na gusto kong sumigaw
Gusto kong ayusin siya, pero di ko alam gawin
Gagawa nga ba ng bago o one big fight pa rin
Ito ba’y totoo o isang panaginip
Di ko na-back up aking DB ngunit andun pa rin ang entries
Ano kaya ang gagawin kung puro sulat lang palagi
Sabihin man nila na ako’y na-hack
Para sakin OK lang basta there’s a DB at the back
At sa inyo mayroon akong ibubulong
Tatlong buwan na to nangyayari sa akin, tsong

Kaya’t para lumigaya ang iyong blogging life
Mag-backup ka ng DB at ibigin mong tunay
At kung hindi, sige ka puso mo’y mabibiyak
Kahit Internal Server Error ay hindi ka iiyak

Mag-backup ka ng DB
Mag-backup ka ng DB
Mag-backup ka ng DB
Ibigin mong tunay

So you better watch out, you better not cry
You better not pout, I’m telling you why
Mag-backup ka ng DB at ibigin mong tunay
‘Coz the girls and the guys did tell you alright
You better find out if your DB is nice
Mag-backup ka ng DB at ibigin mong tunay

Break it down!

Marck

ID for almost everything: @marocharim

4 Comments

Leave a Comment

Your email address will not be published. Required fields are marked *