Wordpress Backup And Database Optimizer Plugin
If you're new here, you may want to Subscribe to my Updates or to my RSS feed. Thanks for visiting!
I’ve changed my WordPress Database Backup Plugin for the WP-DBManager.
It’s not that I wasn’t happy with the Wordpress backup plugin, but the WP database manager has a big advantage.
I’m NOT a database specialist, so don’t ask me why it happens (if you do know, share it with me in a comment), but over time the database information of your Wordpress blog gets cluttered with overhead.
Therefore I re-organize my database quite frequently to delete any redundant information and thus optimize my tables to run my blog smoothly.
To do that, I have to login to my Cpanel, click PHPMyAdmin, open the database, select all tables and then repair or optimize them.
That is not longer necessary!
Early this week I was browsing tubetorial.com when I found Michael Pick’s post ‘Optimize, Repair And Backup Your Database Within Wordpress‘. I was sold immediately.
Because WP-DBManager displays the actual situation of all your Wordpress tables showing you which tables have overhead. The plugin allows you to optimize and repair them from within your Wordpress admin section. You only have to login at your WP admin panel. The best part is, that you don’t have to know anything about the topic, just press a button and it’s done.
You can even automate the database optimization using the DB Options tab by just setting the number of days for the next automated optimization. Now, that’s what I call a great plugin.
Another advantage of WP-DBManager is, that you can store your backups on your server and manage them from there. You can set a maximum number of backups to be stored in there.
Personally, I don’t use this option. I have my backups emailed to me, but it can be handy.
I do not see any reason for the ‘Run SQL Query’. Maybe that’s a comfortable option for the more technically inclined amongst us. Especially since you can only use INSERT, UPDATE, REPLACE, DELETE, CREATE and ALTER statements.
A simple SELECT query would have been handy, but is not possible as far as I could see.
The biggest DISadvantage I see is that you are offered an option to empty and drop tables. That doesn’t make sense to me, unless you’re de-activating a plugin for which you don’t need the tables anymore. But it’s a very dangerous option to put into a plugin if you ask me.
For the rest I’m very happy with this database management plugin.
Try it and post your comments below. I’m curious as to what you think about this database manager.
May 16th, 2008 at 2:57 pm
Excellent post. I’m downloading this plug in now. i’m tired of backing up / optimizing mysql on my own. Theres no reason WP doesn’t have this as a standard feature.
May 16th, 2008 at 4:21 pm
Even though this is something that I do manually at this time I’m always on the lookout for a good one like this. I agree with you on all the advantages of this plugin but I personally won’t be installing it on mine, simply because I get click happy and am a clutz and I can see myself hitting the “con” of this quite easily. I’d hate it if I accidentally dropped my tables. But it might be worth it if there was a warning or something when those options were checked. Might just be talking myself into it here now to give it a try on a small WP install and see.
May 16th, 2008 at 5:07 pm
Why not take a time to understand PHPMyadmin? Be a webmaster, I advise to avoid plugins.
May 16th, 2008 at 6:30 pm
@Jolin
Who says I don’t understand PHP? I described the process above, didn’t I?
Who says I’m not a webmaster? I run this blog.
Avoiding plugins that save time is not smart in my book.
Time to detach your emotions from facts?
May 17th, 2008 at 6:49 am
Thanks for telling about this. I’m really bad at working with databases and really lazy at backuping them. This’ll be really helpful.
May 17th, 2008 at 3:22 pm
Case,
I’d be lost without plugins. I’m a webmaster and understand css/php 101. but that is it. So I appreciate you talking and writing to different levels of people in your blog posts. I’ll check this out. Stumbled too! Thanks
May 19th, 2008 at 2:12 pm
Thanks this is really helpful. I love your blog, so I decided to subscribe.
May 19th, 2008 at 8:31 pm
i’m always afraid to use this kind of plugins, as Jolin says, i prefer to keep using phpmyadmin. anyway, nice post, thanks!
May 19th, 2008 at 10:29 pm
Im currently using WordPress Database Backup Plugin which emails the backup to me. But this plugin u mentioned sounds better. I’ll check it out
May 20th, 2008 at 1:57 pm
Wow,I didnt even know something like this exists. I’ve dont have much experience with databases, I only hope I wont have to learn about them. So this plugin would really save me some time.
May 20th, 2008 at 9:47 pm
I find using MyPHPAdmin cumbersome. Thanks for the plugin.
May 28th, 2008 at 5:26 pm
I do have a database plugin, that emails my backups each day to my Gmail account. It works great. It doesn’t have the optimization options though. I’ll have to check it out. Thanks.
May 29th, 2008 at 4:44 am
Thanks for your informative post. Your readers should feel very glad to know about this. Same as me as well.. give you a thumbs up! @_@
June 1st, 2008 at 1:31 pm
Good find, I’ll have to look into it. I wonder if it’s WPMU-compatible, because that’s what I use
Stumbled
June 7th, 2008 at 2:16 am
This is very useful information and it may help to all needed person.I have used many times word press.Its quite good CMS.
June 10th, 2008 at 7:14 am
I am horrible at all things database, backup, etc. thanks!
June 20th, 2008 at 9:44 pm
I have to say that I’ve used both PhpMyAdmin as well as the DB plugin and the plugin by far is the most user-friendly in my opinion. Thanks for pointing out the plugin for all the newbies out there!