Daily DB Backups FTW!!
I did something stupid last night: I deleted this blog.
Yes. I DELETED it.
Last night, I was cleaning out my various test installs on my cPanel – you know, phpBB, BuddyPress, bbPress & a few of my own pathetic attempts at LAMP coding. While trying to delete one of those DBs, I accidentally deleted the MySQL DB that handles THIS blog. The worst part is I didn’t realize what I’d done until this morning when the blog showed a “500 Internal Server Error”.
My heart sank.
And then I remembered that I had installed the WP-DB-Backup plugin. I was taking daily backups & emailing it to myself! FTW! The rest of the process was pretty simple:
- Create a new database with the same name as in your wp-config.php file.
- Download the latest backup file from your email inbox.
- Go to phpMyAdmin & import the latest backup file that you just downloaded.
That’s it. The blog is now ‘back up’ online! :)
In hindsight, it probably doesn’t seem like a big deal – but it would have been a HUGE deal had I not activated the WP-DB-Backup plugin in the first place. What would have happened if I hadn’t activated the plugin & didn’t have daily backups?