So I woke up this morning and jumped over to my blog. I noticed that my theme was still installed and that I could still log in to my dashboard but that there were no posts on my front page. All I saw was a “Page Not Found” error. I logged in to my dashboard and saw that every single post and page that I have ever created had been deleted. I have no idea how this happened but everything was gone. The database that held all of the information on my blog had apparently crashed. I freaked out a little bit and then remembered that I had taken some actions to safeguard against situations like this. I spent about 5 minutes reloading my last backup and everything was back to normal again. I may have lost one or two comments that may have come in over night but, for the most part, it’s like it had never happened.

It is scary because if I hadn’t have taken a few certain actions a few weeks ago, I would have been unable to recover my blog. I figured that there are probably a lot of bloggers out there that may not know how to backup their blog or how to recover their blog from a backup. It is really scary because your blog CAN go down at any time for no apparent reason whatsoever! Read this post and maybe you can put yourself in a situation where a database crash is nothing more than a 5 minute fix.

The very first thing that you should do is download and install the WP-DB-Backup plugin for wordpress. It’s a free plugin and can usually be searched for and installed from directly inside your WordPress Dashboard. Get that installed today. Once it’s installed set it up to backup daily and send you an e-mail with the backup. By doing this, you can jump back to any point in time and recover all the information that crashed. If you don’t update very frequently, you can also opt to backup weekly. I prefer daily because I know I can restore comments from the previous day as well.

Now… If your blog ever goes down and you have been doing a good job of backing it up, here is how you restore your blog.

1. Login in to your CPanel account and scroll down until you find phpMyAdmin

2. Find the database that your blog is installed on. The backup files that are sent to you from WP-DB-Backup will share the same name as the database you need to recover. So if you are unsure of which database to open, refer to the filename of your backup file.

3. Click on the tab that says import at the top of the new screen that just opened.

4. Click on “choose file” and find the backup file that you are going to use to restore your blog.

That should do it. Your blog should be back in all of its glory. Having a database failure can be extremely scary! Fortunately, if you take the right precautions from the beginning, it can be a very quick and painless fix. If you only have one plugin installed for your blog, make sure that it is a backup plugin. It will save you someday!

Please feel free to make comments. Have you had your blog crash? Do you have any questions about making sure you are protected against your blog crashing?

You may also be interested in:

1. How To Set Up A WordPress Blog
2. The Best Plugins For WordPress
3. Giving Your Blog Curb Appeal
4. How To Schedule Posts For Later
5. I Teach How To Blog But Don’t Blog Myself

16 Responses to “Last Night My Blog Crashed”