Let’s face it: Murphy’s Law is always waiting to rear its ugly head. In more blunt terms, shit happens. And in blogging, the sight of a 500 Internal Server Error is one those dreaded errors capable of inducing cold sweat. Take it from me because just this weekend, I came face to face with this depressing error once again, this time is for another reason but stupid rookie mistake nonetheless – I accidentally deleted the host database.
Was I able to recover from it? Yes and no. Yes, I was able to get my page back online. No, I lost all my blog posts.
So what did I do to resolve the problem?
1. Accepted fate. Two days after trying my luck by installing, de-installing, and re-installing WordPress 3.4.2 using Filezilla, I accepted the fact that this isn’t the solution. Time wasted but sanity recovered.
2. Gathered composure. After accepting the fact that I just wiped out years of blog posts, I gathered my composure and sought online help. While my search led me to a WordPress.Org help forum where the answers weren’t direct, it gave me a hint on what to check.
3. Created new database. From the emotional part comes the technical aspect of recovering from a 500 Internal Server Error. Based on experience, wherein I encountered compatibility issues between GoDaddy’s Domain and Hosting settings, I created another database with MySQL version 5. This one took only around 10 minutes to do.
4. Modified the file wp-config.php. Assuming that your GoDaddy FTP File Manager is set up properly, this step is surprisingly easy. From the newly created database, I took note of three (3) items: (1) DB Name (this is the usually the same as DB User), (2) DB Password, and (3) DB Host, and then placed these on the wp-config.php file. Here are the lines that need to be changed (underlined):
// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
/** MySQL database username */
/** MySQL database password */
/** MySQL hostname */
5. Moved on. As expected, I opened my site and was welcomed by an entirely new page, fresh page, all blog posts gone. But there is no point in crying over spilt milk, or in this case a wiped out blog; so yes, moving on and starting all over again is the last step in this process.
I am now trying to decide if I should continue catering nuffnand adds. About a month ago I checked and I have got some payment for having it on my blog – about 6 pesos. Yes, just 6 pesos.
Mood: 2/10 Honks! (I heard my wife will be going to SM. Note to self: avoid the cashier near the men’s section.)
October 1, Philippine time. If you have been an avid fan (indulge me) of this blog and returned to discover that something is amiss, well, you are right. That is because over the weekend, with me taking a day off earlier than usual because some of my colleagues suggested that I grab the extra time off slot, whatever their reasons are, which I gladly accepted anyway, I tried to install an Instagram plug-in so that I can integrate wifey’s photos but unfortunately I got careless and clicked on the wrong file — and of all files, the main database — on my GoDaddy.com hosting page. And to make the story short, that wiped out ALL my blog posts.
Thankfully, all is not really lost. Two months ago I got another plug-in called Feedfabrik that made me save all my blogs, at least until July 2012, into one e-book consisting of around 1,200 pages. I can also recover some from my old wordpress.com but these contain a lot of grammar error than my recent posts so it might take some time before I review and completely edit these posts and proudly showcase them on marcuscanblog.com.
Lesson learned: back up, back up, back up….the right database.
Mood: 2/10 Honks! (Happy Blogger!)
Welcome to WordPress. This is your first post (after you made a SNAFU by deleting your host database). Edit or delete it, then start blogging!
“It is easier for a father to have children than for children to have a real
father.” – Pope John XXIII
How many times have we been in the church to hear mass and expecting it to be one that so solemn, it relieves us of the past week’s stresses and readies us spiritually for the next? But how many times have we been distracted by kids who have decided to make the pews and the altar their playground and tried testing whether they can generate an echo in every corner of the church? Much worse, how many times have we been the parents of these restless Sunday kids?
To answer the last question, it has been happening to us a lot lately. Thanks to our ever active son, whether he is sick or not, Marcus.
Because like karma proving itself true, I now realize that my past encounters with unruly kids and how I have secretly cursed them and/or their parents while I try to fake a smile and maintain composure as I do my Sunday prayers have finally caught up on me. I seem to now slowly accept the fact that even my most fervent prayers may not work to pacify one restless son. I am now among the helpless parents who can’t do anything but pray for divine intervention – and one that is less likely to happen at all. I think God doesn’t touch uber active children but rather he makes parents ponder what was done and what still needs to be done to produce one well-mannered kid inside the church (or any other place).
So please if ever you get to be one lucky church person, because you are
either single or married but still childless and whose only problem is if your
message to the mighty heavens gets across, please understand that if you
are annoyed by kids running uncontrollably around you, bear in mind that someone among those bowed head somewhere is a helpless and embarrassed parent of that kid and ever wondering if indeed God created restless children, too.
Mood: 2/10 Honks! (Dear God, Thanks for Sundays.)
Demolition. Scarborough. Demolition. Scarborough. Demolition. Scarborough. These continue to flood the news and both have something in common. I realized that the slums is a microcosm of the ongoing conflict that is happening between us and our neighboring countries who claim that they too own Scarborough Shoal and the Spratlys Island. This local and international news mixed up has been so strong that I think that there are things from the steadfast squatters that every country uses too to strengthen their own claim of the disputed Islands in the South China Sea:
1. Our parents said it’s ours, so it’s ours. (According to web references, the Chinese believe that these islands are theirs since 200 BC.)
2. We were born here, so it’s ours.
3. We’ve already built a house here, so it’s ours. (Several claimants have built their own structure in Spratlys.)
4. No relocation, no deal. (Personal appeal: please relocate me to the West before you guys resort to #5.)
5. Mess us and we’ll mess with you. (This can get ugly…or stinky at the very least. Let’s avoid this at all cost.)
Mood: 3/10 Honks! (Hot Monday morning but wifey and Marcus don’t seem to care—they’re still in bed.)
I think I shall never see
A sad poem about a parking lot made by Mr. Sy.
A parking lot whose chilly basement is pressed
Against Baguio’s once abundant pine tree crest.
A parking lot that looks at the mall all day;
And waits for cars of shoppers who pay.
A parking lot that covers people in Summer wear;
A nest of evicted bird species in its lair.
Upon its concrete levels Baguio’s cold has lain;
Insensitive of the dead forest’s pain.
Poems are made by fools like me
But only greedy men can uproot hundreds of pine tree.
Credit: Poem derived from ‘Trees’ by Joyce Kilmer.
Photo derived from http://www.freephotosbank.com
Mood: 1/10 Honks! (Monday and WE are home.)