ejcross.com

Ok, it’s time to tell on my stupid self. While I was checking on my server and trying to clean up some of development files, I thought I would clean up my old databases also. So, I started working through all of them and trying to clean up some of the old “trash” databases. Well, I guess it goes to show that you really should know which database goes to which site before you delete it. Luckily I have been using the Wordpress Database plugin!

If you are worried or haven’t thought about what would happen if you lost your database, let me tell you it’s no fun to go into panic mode when something happens to your site. My iPod site was getting a lot of hits over the last few days, so I was really happy with that fact.

One of the things I learned early on with blogging, no matter what your blog is about is to be prepared. I guess I learned something in the Scouts too! I have been using the WP-Cache plugin to handle the heavy user loads on my sites, and it has worked like a charm. But, how can I manage all of the databases on my sites easily?

I found and have been using the WP-Database plugin for several months on most of my sites. I can tell you that it is a lifesaver!

When I was going through cleaning up my databases, I deleted what I thought was an old db to an old site. What I didn’t realize was the old db was already gone, and in it’s place was the new one for my iPod site! YIKES!

So, much to my surprise, when I went back a few hours later to check on my stats and see how my new keywords were doing, I got the infamous “couldn’t connect to your db” message. Crap!

Enter WP-Database plugin

Since I have been using the WP-database plugin, I had forgotten about having it running. You see, it can repair, optimize and backup your wordpress database. Automatically. All you have to do is “set it and forget it”.

When I realized that my db was gone, all I had to do was recreate it in my phpAdmin, and then reinstall the most recent backup that WP-database plugin had created. Sure, I lost a couple of my more recent posts as it had completed it’s backup before I posted today, but it was a lot better than loosing it all!

Some of the other neat features of the WP-Database plugin are that you can manage your backups, empty or drop tables, optimize your database (if it is slow), repair it (if it is wacked out) and set a lot of options for it to run on its own.

The plugin is created by lester chan and he also has some other great plugins worth checking out on his site. A couple that I am going to be looking into are an IP blocker for wordpress and a download manager.

I guess the best thing I can say is always be prepared for the unexpected, especially yourself! Try this plugin and I hope it saves you one day too (well, not really, I wouldn’t want you to go through this!).

Share this article:

Thanks for stopping by and visiting ejcross.com! Did you like what you found? You can subscribe to my RSS feed or use the Trackback URL. Thanks!