Backup WordPress Database The Easy Way

Most web hosting providers do a daily backup on their servers. In case of any failures on the primary harddisk, there is always a backup to fall back on. However, these backups are never or at least seldom guaranteed by web hosting providers. Therefore, it is always advisable to have a backup of your database yourself.

Here are two methods where you can backup your database.

Method #1: Manual backup through cPanel (control panel)

You should be given a control panel to manage your account. The type of control panel depends on a few factors including the operating system that you are on. If you are using something else apart from cPanel, you will need to check how your control panel works.

Use cPanel to backup database

For cPanel users, click on the Backup icon. You will then be directed to the backup page where you can choose to download a backup or restore your database with your previous backup.

Download database in cPanel

Click on the link of the database that you want to download.

Method #2: Automatic backup using WordPress Plugin (the easy way)

The WordPress Database Backup plugin can be setup to backup your database automatically. This plugin is very useful and easy to use.

Wordpress database backup plugin error

After activating the plugin, go to “Manager … Backup”. If you see an error message such as “WARNING: Your wp-content directory is NOT writable! We cannot create the backup directory.”, you have two options to solve it. The first method is to set the permission of the wp-content folder to 777 (remember to change it to the default settings later). However, I recommend creating the backup folder manually. That way, you don’t risk leaving the permission of the folder to 777 and risk any potential attack.

The backup option page is split into two parts. The top part is used to download, save a copy in your server or send a copy of the backup to your email. The bottom half is used to configure automatic backups. You can select the frequency of the backups — never, once hourly, once daily or once weekly. The backup will be sent to your email address. Click on the submit button when you are ready.

The frequency of the backup should depend on a few factors including the number of posts you publish and the number of comments you get. If you publish a few posts daily and/or you get a lot of comments daily, it is best to backup daily. Or else, do it weekly.

Do it now

Many others have recommended this plugin as a “must have” for bloggers. Unfortunately, not everyone has taken the initiative to activate this plugin including myself. Well, I have just activated it a few hours ago and it is working like a charm. You should do it too before you lose your posts and comments to a harddisk failure.

Visual Tags Button For WordPress 2.3

A few new features were implemented in the latest WordPress 2.3. One of the additions was integrated tagging support. If you were using other tagging plugins previously, you can import your tags using the importer tool. This is a great addition to the core system but it lacked visual display for the available tags. There should have been a section that displayed all previous used tags just like what is available for the categories section.

Click Tags was developed to overcome this problem. It adds the list of tags above the textbox so that you can easily select a previous tag to use. This helps to keep your tagging consistent.

I still haven’t upgraded to version 2.3. I have read some people having problems with it. I will consider upgrading when I have the time next week.

U Comment I Follow, After X Comments

The old dofollow plugin will remove the nofollow tag from the comments. This is a good way to encourage people to comment because it provides a linkback to the person’s blog or website. There are advantages and disadvantages of this plugin. One of the negative impacts is that removing the nofollow tag may invite more spammers to your blog.

The upgraded dofollow plugin developed by AllPassion takes care of the problem above. With this new plugin, the nofollow tag will only be removed after an individual has commented at least 10 times. Note that this number can be changed by editing a variable in the plugin file.

I am thinking of joining this U Comment I Follow movement as well. I am still considering. Anyway, if you want to activate this plugin, you can get one of the U Comment I Follow badges from Randa Clay. Tell the others you have removed the nofollow tag and (hopefully) see an increase in comments.

Have you activated the dofollow plugin? If you haven’t, why aren’t you willing to activate it? Would you activate it if I were to activate it? U Activate, I Activate :-P

[Via Ankesh Kothari]

Hey You, Douche Bag!

As a blogger, have you encountered people leaving annoying comments in your blog? Have you thought of slamming them back with a reply but didn’t want to look bad doing it?

Travis from Young Go Getter dot com has come up with a nice WordPress plugin named Douche Bag to do the dirty job for you. When the plugin is activated, all you need to do is to append the Douche Bag code onto the person’s comment. When you are done updating the comment, a douche bag will appear by the side of the person’s comment.

Wordpress Douche Bag plugin

This is a sweet and indirect method to tell the person leaving the annoying comment, “Hey, you have been officially labeled as a douche bag!”

Ditch Akismet For A Better Alternative

Everyone hates spam, unless you are a spammer. I’ve been using Akismet to block spam since the very start of my blogging life. It has successfully eliminated over 1,000 spam comments for me. However, there were also instances where it mistreated my reader’s comments as spam thus forcing me to de-spam them manually every single time. Occasionally, I had to manually delete spams that it did not “dare to delete”.

335 comments that Akismet failed to automatically discard

I’ve been patient but it’s time to end this “partnership”. For the past 7 days, 335 spams were collected in the Akismet “dare not delete” list. It took me a few minutes to scan through the list to ensure no false positives were made. It’s time to give the other spam blocking plugins a try.

Mooiness suggested that I use the combination of Bad Behavior and Spam Karma 2 some time ago. It’s an easy installation with minimal setup required. Unlike Akismet where you need to obtain a WordPress.com API key before you are able to run it.

Please help me test out this plugin by commenting (as many times as you like) below. Yeah, I’m fishing for comments. Can or not? :-P