this is why I'm not a db admin [Tue, 02 Jul 2013 01:05:58 +0000]
I was debating switching from Godaddy to HostGator over the weekend and while browsing through my account, I deleted an entire MySQL database - the one I use for demo apps like searching through timed text files, etc.
Thankfully I'm better at documentation than, oh, not deleting databases, so I should be able to get everything reconstructed in an hour or two. Maybe this July 4th in the morning.
I'll definitely be referring to old blog posts in order to reconstruct enough data for the demos to work - if I don't delete my WordPress db first!
... and I'll definitely be writing cron jobs to backup the database this time around.
Live and learn.
Update, July 4, 2013: Database restored! Apps OK.