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.
Supercharge your blog’s earnings with Text Link Ads
Episode links:
- Lester Chan’s WP-DBManager
- One-click WordPress install from Colorteck!
- Repair your database manually in phpmyadmin
- Backup your database automatically with a cron job.
- 7 Must Have Killer WordPress Plugins Series Index.
Tubetorial made by Michael Pick, a professional screencaster, when he is not swearing at Final Cut Pro on his Mac Book Pro.
Excellent video. I needed this, b/c I am clueless when it comes to DB and php.
Great video! You make this stuff look easy, I always had a *natural* adversion for this techie things…
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.
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
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.
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
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
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 (http://www.ilfilosofo.com/blog/wp-db-backup)
🙂
QFT
“PhpAdmin scares me, but WP-DBManager is so simple and automated too. This is my number one favourite WordPress plugin, bar none!”
thanks a lot for this article. Basicly i just have getting started to learn, how to optimize database.
Thanks.
Will this plugin work in a WordPress MU environment?
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.
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
Excellent vedio
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 !
Thanks going to try the DB manager plugin on my site which has been experiencing some perf issues.
Hi Michael,
great tutorial. Now I understand how to work this.
I appreciate the clarity of your demontration!
Yorinda
I have been blogging for over a year now and this is something I have yet to achieve.
Nice tutorial buddy.
Good work.