It’s kind of hard to make money online when your monetized website is down. The situation gets even worse if someone hacked into your servers and messed around with all of your files. That’s why it is of paramount importance to back up your self-hosted WordPress blog on a daily basis, just in case something bad happens. This way, you can quickly and easily restore your blog back to how it was before it was hacked.
There are manual ways of backing up all your databases and such, but why go through all that trouble when there’s an automated way to back up your blog? The aptly-named WordPress Database Backup plug-in created by Skippy and maintained by Austin Matzko fits the bill perfectly. It’s a one-click solution… in fact, it can even be a no-click solution, because there is an option for the system to automatically email your backed up database (as a .sql.gz file) to you on a daily basis.
More instructions about installation and implementation of this invaluable plug-in can be found on its official page.
Matt
June 6, 2007 7:34 pm
Actually, it’s a .sql.gz file…
Also, technically, Skippy made the Plugin, Austin Matzko just took it over.
James
June 7, 2007 10:00 am
Database backup is a very good thing. In the unlikely event I need the backup, could you guys suggest (maybe as your next WordPress Wednesday) how to restore a failed database?
Rhetorical
June 7, 2007 3:36 pm
Thanks Matt. I’ve updated the post.
Matt
June 7, 2007 4:44 pm
It’s simple, just login to cPanel, go to phpMyAdmin, choose the database you want to restore the backup into, and click the “Import” button near the top-right of the page. Then, choose the file you want to restore from, and click on “Go”. Simple as that. :D
Linus
June 8, 2007 6:36 am
Thanks. That’s very simple and very helpful. I’ll start doing the backups immediately.