Close Call, Always Backup Your Database

Server
This day, I have some problems with WordPress Plugins. It’s not that the plugins were having problems due to WordPress recent updates, like the one Les has experienced, it’s more to human errors. My errors. I know that some plugins must be updated each time the latest WordPress updates is published. I also having the same problem when updating my WordPress to 2.3.1, but that’s a different issue. What I’m going to talk about here is more important than just plugin anomaly. It is when humans makes mistakes.

Last month I had an offering from somebody’s post (I forgot where it was) about free web hosting at freewebhosting24/7. It is a good offers, 500MB free space and 10GB bandwidth per month. The Free space offers is doesn’t matter because this blog only consist of database and the pictures were hosted outside the web using Photobucket. However, bandwidth is an important thing. Your site need a bigger bandwidth to allow thousands of visitors per day. But that’s not only the offers, unlimited MYSQL database, addon domain names, parked domain names, subdomains, email accounts, email auto-responder and forwarder. Usually, other free web host only offer limited amount of MYSQL database. It’s way too good for an offer. That’s why, during last year’s Christmas, I tried to import my Blogspot blog.

Not too long after I manage to import all the Blog content using WordPress’s magical button, I was offered to some kind of big project. To develop layout design for Kamus Ilmiah.com, an online Indonesian dictionary for terms and vocabulary related to various study. Despite the reward that I’ll get (great leap in my personal portfolio), I got a subdomain to host my website, under the domain of Kamus Ilmiah.com. This is great! That’s why, during January 1st 2008, firewalker.kamusilmiah.com is born.

Then I remember that I got a wasted subdomain at freewebhosting24/7. It’s already registered as my real name: didikwicaksono.freewebhosting247.com because I really wanted to follow the path of David Airey’s in making his own site. I also remembered that the name were too long and sophisticated. The name Didik Wicaksono is consist more than 10 characters which will definitely makes people mis-spelled the URI. Well, I won’t get enough audience by this. So, yesterday I decided to make this didikwicaksono.freewebhosting247.com to become my Personal Blog while firewalker.kamusilmiah.com as my portfolio and graphic design related blog.

I need to distinct the Personal and Non-Personal posts, luckily I already categorized it. However, WordPress didn’t have the feature to massively delete all post within categories. I need a plugin for this. That’s why I search for WordPress post plugin at WP-Plugins. I found out this plugin: Mass Post Manager. It’s a plugin byVolodymyr Danylyuk.The function is to delete or move posts within categories. The latest function is to delete all spammed comments.

The procedure is like this:

  1. I delete the ‘Personal’ category, which will be automatically moved by WordPress into a category labeled as default. The default category at that time was labeled as ‘uncategorized’
  2. Then I delete all post within ‘uncategorized’ category using Mass Post Manager
  3. However, I forgot that the static page was also labeled as ‘uncategorized’ by default
  4. In other words, all my static page was turn to ashes! For God Sake!

Luckily, I already installed this plugin: WP-DBManager A plugin by‘GaMerZ’ Chan. It’s a must have plugin! It’s not just that it provides you with interface to control your SQL database, it also created a regular backup to your backup folder or send it to your email in both SQL and GZIP format. My last scheduled backup was January 6th, three days ago. I only need to update the Static Page, not the whole database, because recently I got a nice comment from David Airey in the previous post which I will never miss it. With a limited time and knowledge, I manage to run the SQL command to insert the page.

Now, I’m setting up my database to backup every 10PM. I won’t missed some opportunities for some human errors.

Blogged with Flock

Tags: , , ,

Comments

 Give your comments about this article

 Give comment







logovcard

I am a website designer who create website that really works and easy to use. I am capable of creating website with XHTML, CSS, and jQuery. WordPress is my preferred tools of trade.

Saya adalah seorang desainer website yang mampu membuat website yang benar-benar berfungsi dan mudah digunakan. Saya dapat membuat website dengan XHTML, CSS dan jQuery. WordPress adalah piranti pilihan saya.

 
I am not available for design work at this time
Saya tidak bisa menerima pekerjaan desain untuk saat ini