Backup WordPress Database

Backup WordPress Database with “WP-DB-Backup” Plugin

The database backup is one of thing that must be done by blog admin. The database is needed to recover our blog if something bad happen. It is because WordPress database contains every post, every comment and every link that we have on our blog. As Wordpress.org user, I use “WP-DB-Backup” plugin to backup this entire Online Knowledge blog database. I use “WP-DB-Backup” plugin because it is really easy to backup Wordpress database if compare by using phpmyadmin or MySQL directly.

“WP-DB-Backup” Wordpress Plugin Installation

Go to “site admin” page

Click “Plugin” tab

Click “Add New” button

Insert “WP-DB-Backup” in search box

Click “Search Plugins” button

Click “Install” button

Click “Install Now” button

Click “Activate Plugin” button

Ok, the installation already done successfully. Now, I need to do some configuration so it can be used in optimal way.

Configure and Use WP-DB-Backup Wordpress Plugin

Still in “site admin” page

Click “Tools” tab

Click “Backup” button

Check “Exclude spam comments”

Go to “Backup Options” part

Check “Download to your computer”

Click “Backup Now!” button

Wait for running progress

The save pop up appear

Save the backup database file to my laptop

Go to “Scheduled Backup” Part

Choose “Once Weekly” as backup schedule

Click “Schedule Backup”

Please note that the “/wp-content/backup-b4283/” file must have 777 as File permission so all the backup step can run normally. We can easy change this file permission by use FTP client manager such as FileZilla. But, if your webhosting use phpsuexec facility in their hosting server, we do not need to change file permission to 777.  We can run the backup process normally even without change the “/wp-content/backup-b4283/”  file permission. It is more secure like that of course.

Ok, All done! I already use this “WP-DB-Backup” plugin successfully. I already backup this Wordpress blog database to my laptop and also already setting backup schedule that will deliver this Wordpress database backup each week to my email.

Conclusions

It is quite easy to backup WordPress database by using “WP-DB-Backup” WordPress plugin. We can have scheduled backup for automatic backup. There are some suggestion that we must only do database backup trough “Backup now!” facility instead use “Scheduled Backup” facility. It is for security reason. You can always deactivate this “WP-DB-Backup” plugin directly after use it if only use “Backup Now!” facility, but this “WP-DB-Backup” plugin must remain active all the time if we use “Scheduled Backup” facility.

Yeah, there is always some trade to get on purpose. The blog admin must make choice according this situation. Always choose something base on your needs. I, my self, decide to use “Scheduled Backup” facility this moment for experience sake. I also dare to do this because my web hosting provider use phpsuexec which make I do not need to change backup file to 777 file permission. I may consider to only using manual backup with “Backup Now!” facility in future. Who knows?




That’s all update this time, wait for next update!

Author: dana (100)

Dana is the founder of LetUpdate dot Com , a blog where he share much about blogging, and little about internet and IT. Yup, You will find many knowledge sharing about blogging here, and also knowledge sharing about Internet and IT sometimes. You can subscribe the LetUpdate dot Com Feed or twitter @danalingga to be updated.

Other Great Articles:

1. WordPress Upgrading: 2.8.5. version
2. Blogging Disaster Recovery
3. Create Wordpress Blog Lab
4. Create Contact Form for WordPress Blog
5. Tweaking The Wordpress Comment
6. Why am I so Late for WordPress 2.9 Version Upgrading?
7. Install All in One SEO Pack Wordpress plugin
8. How To Uninstall WordPress Blog Manually
9. Install Favicon and make difference
10. My First Web Hosting Problem Experience