Migration

Our recent trip to the US had me think of the possibility of migrating. If that’s going to happen, we never know when and how. I know we are all unanimous in wishing we stay there for good. Anyway, the only migration that’s going to happen this year is the one from my self-hosted blog back to the free WordPress.com. My GoDaddy subscription ends this March and I have decided not to continue it as it is becoming more expensive to maintain. My initial plan back then was to have this blog monetized through ads but it never happened the way I expected it to be. Nuffnang wasn’t just enough to cover the renewal fees and this year subscription to the cost of the economy alone has tripled. It was only P7000 the last time I paid for it. I have already started the transfer to the free blog environment and I am now in the process of linking marcuscanblog.com to marcuscanblog.wordpress.com so all updates moving forward will be done on the latter.

***

img_20170116_095441_zpspgq1av0l
We heard there’s a new McDonald’s nearby so we tried its drive thru  last Sunday night. The attendant was good enough to take our picture and I think this one reveals the pounds I have packed during the vacation.

***

Mood: 2/10 Honks!

Advertisements

GoDaddy: How to Solve 500 Internal Server Error

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 */

define(‘DB_NAME’, ‘IAmACarelessBlogger‘);

/** MySQL database username */

define(‘DB_USER’, ‘IAmACarelessBlogger‘);

/** MySQL database password */

define(‘DB_PASSWORD’, ‘IWillbeMoreCarefulNextTime‘);

/** MySQL hostname */

define(‘DB_HOST’, ‘ClickOnThePencilIconAndThisOneCanBeFoundBesideHostName‘);

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.)

Another Fresh Start for MarcusCanBlog.Com

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!)