How To Backup Wordpress Database

Today I lost my whole blog (this one).

Thank goodness, I had a backup of my database. Your database is where all your Wordpress Blog’s content is stored on your hosting account’s server. Most of you will never have to know about this or go into it.

Luckily, I had a backup and was able to bring the blog back but I did lose to posts. The coaching post and the “Don’t upgrade to Wordpress 2.8″ post.

I also lost some comments too. Talk about being bummed out!

OK, please, please, please, if you are blogging with Wordpress, backup your database!

The following is how you do it:

1. Login to your hosting account’s cpanel. If your hosting account does not have cpanel, change hosts.

2. Look for an icon called “backups” (1) and click on it.

backupdatabase1

3. Click on what database to backup (1). If you are not sure, backup both. As soon as you click on the link (1) It’ll start downloading. Save it in a safe place. To bring your blog back to the state it was, click on browse (2) and select the database your want to restore. Then click “Upload” (3).

backupdatabase2

Please backup as much as you like but at least once a week.

If you forget and something happens, ask your hosting account if they can roll back your database to the last backup they have. They do this too :-)

For those of you that need video (I do) See the following:




3 Responses to “How To Backup Wordpress Database”

#1087. Emelie Says:

Thanks alot for the easy instructions!

I just did my first wordpres buckup and it worked perfect :)

Cheers,

Emelie

#1505. Oliver Says:

This the best advice a webmaster can get, losing all you source files is a disaster.
For for that matter EVERYONE needs a backup of important stuff.

As a computer tech, I have seen many instances of people losing files because a hard drive fails. Today, with all the back up options available, there is NO excuse for losing those cherished bytes.

Always, always, back up your WP database after every post.

There is a very good WP plugin for this at here that I use.

BTW, I love this blog.

Oliver

#1672. Charles Says:

Hi Craig

Thanks so much for showing me how to backup my database. You made it look so easy. Thanks for willing to help newbies like me trying my hand at Wordpress. It is always refreshing to know that there is help available from people like you. God bless you.


Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>