Back up your WordPress Database or lose it

wp-db-backup(Note: This post is intended for those who host their own WordPress installations, not those who use

I have a regular monthly meetup with a couple other new media minded friends and today an interesting topic arose. All of use use WordPress to host one or more of our blogs. During the conversation we fell upon the topic of WordPress Database backups. If you use WordPress, it is imperative that back up this database regularly as it contains all your blog content.

Unlike a typical web site made from static HTML pages, WordPress stores all of its content in an SQL database. If you are new to WordPress, or your blog was set up by your web designer, you might not even realize this. This is where a lot of people run into trouble. Typically, it isn’t very easy to back up this database, even though it is critical. Most explanations talk about logging into the database using phpMyAdmin and performing a manual series of steps. This is clearly beyond the abilities of many bloggers, who just want to write their blog, not become a sysadmin, as well.

That said, there is an easy way to backup your WordPress Database and store it away for safekeeping — automatically. WordPress Database Backup is a great plugin that works automatically and will even email you your database so it can be backed up with your normal PC files. In my case, I setup a seperate Gmail address that collects and stores these backups in case I ever need them.

While the WordPress database is extremely important, you will also want to back up all the WordPress files in your blog directory using standard FTP tools. These contains all the source code, theme files, plugins and more that allow your blog to operate in conjunction with the database.

Backup your WordPress database today and regularly. If you don’t know how to do it, contact your web designer or web host and have them assist you. You don’t want to lose your blog to a preventable error.

Reblog this post [with Zemanta]