Optimize, Repair And Backup Your Database Within Wordpress

7 Must Have WordPress Killer Plugins: Optimize, Repair and Backup your dbase

One of our most popular tubetorials is the Backup Your Blog video, but the functions is the backup plugin are rather simple and limited.
Actually you want more than just backup your blog, because what will you do with the backup once you need it? Do you know how to restore your database, how to import your backup? Did you know that you have to do this within phpMyadmin, in your CPanel???

Another problem with databases is that with time they will create overhead, unwanted clutter. Almost as bad as fragmented hard drives in your desktop PC. They will slow down your database performance and in worst case they might even damage things.

The road to repair or import a backup usually goes over Cpanel and requires several operations within phpMyadmin.

But you don’t have to suffer, because there also is an easy way to do all this. With Lester Chan’s awesome WP-DBManager you can control your complete WordPress database in your WP admin panel. Backup, restore, repair and optimize your database, without any knowledge requirement.
You can even run SQL commands and add new tables to your database.

Things couldn’t be easier.

Flash video: 9:13 in duration

Supercharge your blog’s earnings with

Episode links:

Tubetorial made by Michael Pick, a professional screencaster, when he is not swearing at Final Cut Pro on his Mac Book Pro.

Share this page or bookmark it now!

9 Comments ↓

  • Optimize And Backup Your Wordpress Database | Michael Pick said:

    […] Episode three of our Seven Killer Must Have Plugins series for Wordpress is live over at Tubetorial. Today’s plugin is a cool way of making sure that your Wordpress database stays optimized and backed-up with a minimum of effort. If you’re wondering what the hell that means, you probably need this plugin. […]

  • Scoot said:

    Excellent video. I needed this, b/c I am clueless when it comes to DB and php.

  • Vince said:

    Great video! You make this stuff look easy, I always had a *natural* adversion for this techie things…

  • Val said:

    Thanks for this lesson. I wish I had it a few weeks ago. I’m starting from scratch again since my super cheap hosting just super blew up. No backups. Ouch.

  • Stephen Anderson said:

    Thanks Michael,

    I love you videos, very easy to understand. I just installed WP and went through your series. I then went back to the 7 essential hacks series and the back up tutorial seems to be a bit different there. If I just do what you have instructed will that be fine?

    Thanks

  • Clive said:

    Excellent video and plugin - previously I was FTP’ing my whole blog to my hard drive, saving my database from my Control Panel and running the original WP back up.

    Doing all that made it an easy thing to “put off ’til tomorrow”!

    This is great - I’m recommending the plugin and this tutorial to all my pals who blog.

  • Mark said:

    This is fantastic, I was using a joomla plugin to perform my backups but now i think i will stick with wordpress for my new development project since i know this + its far more easy and more reliable then joomla to perform backups

  • 7 Must Have Killer WP Plugins | KamikaziWeb said:

    […] The Ultimate WordPress Database Optimisation […]

  • Alex said:

    Wow, you are right. Lester Chan’s WP-DBManager is totally awesome!

    PhpAdmin scares me, but WP-DBManager is so simple and automated too. This is my number one favourite WordPress plugin, bar none!

    Thanks for the article about it. Great job!

    All the best,

    Alex

You Design - We XHTML / CSS. PSD to HTML, PSD to XHTML Service. Pro Workflow