Optimize, Repair And Backup Your Data


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??? Having a premier global data center service is essential, but you must also be aware of your own responsibilities.

For example, 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 Text Link Ads

Episode links:

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


Tubetorial

19 Comments

Your email address will not be published.

  1. 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.

  2. 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

  3. 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.

  4. 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

  5. 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

  6. One side note about your presentation, which by the way was great.
    The way this plug-in (WPDBManager) seems to handle back-up might be risky. If someone manage to compromise your web server, there is a great chance that he might get hold on your back-ups (as the default is to store the back-ups on the web server directly). So, the attacker could destroy those back-ups and there would be gone. Or even worse, by accident a potential attacker could grab one of those backups by downloading them from your server (if you are careless with some Apache settings, like displaying directory contents). Then with the database at end, he could get to the hash version of every user password, and he could trick the login form of WP to get instant access to you admin page.

    So a good solution is to backup, then download the backup on your personal computer (and make a backup of your computer), and remove the backup online.
    Or an easier solution that can do all of that alone (it sends you the backup by email) is to use another plugin for backup: wp-db-backup (https://www.ilfilosofo.com/blog/wp-db-backup)
    🙂

  7. QFT

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

  8. thanks a lot for this article. Basicly i just have getting started to learn, how to optimize database.

    Thanks.

  9. Yes… great video.
    I’ve heard lots of good things about WP DBmanager and it will probably be the one that I choose for backup and optimisation.

  10. I messed up my WP database when I updated it to a newer version but got interrupted. Now I can no longer login… Any idea?

    Thanks

    Mandy

  11. I recently installed WP-DBManager in one of my WordPress blogs and it looks to be a helpful plugin to backup up and restore the database for individual WordPress instances
    I want to thank you for great video !

  12. Hi Michael,

    great tutorial. Now I understand how to work this.

    I appreciate the clarity of your demontration!
    Yorinda