The following is a true story, dated today at approximately 11:00 AM while on my way out to lunch. This is NOT a paid post, but I have added a HUGE link to the company in appreciation of them saving my butt!
Development 101 says that when you mess with your code or your data, you always first do a backup. No exceptions. The 15 minutes it may take to do that backup could save you months or years of work.
Today, I broke Development 101.
While I was deleting a plugin, I noticed that there were some accompanying tables associated with the plugin. I quickly selected the tables and clicked DROP.
Of course, the obligatory warning arose from my browser but I, the smart one, already had my thumb over the enter button quivering with anticipation. The next moment happened in slow motion… as my thumb started the trip downward, toward the button, I began to peruse the warning across my browser.
"Are you sure you wish to drop Database mydatabasename?" Click.
I'm not exactly sure why my reading and cognitive abilities were outpaced by my thumb mashing the enter key, but the undeniable happened. I just deleted my WordPress database.
I immediately felt nauseous and a cold sweat broke on my forehead. I quickly opened my FTP application and scoured the server for any remnants of a database that may have been deleted. Unfortunately, web servers don't have a trash bin. They're smart enough to double-check with you before you do something stupid.
As a last resort, I logged into my hosting control panel, opened a support ticket and wrote the following:
I just deleted my database on my server. Please tell me that you have some kind of backup process in place to restore from. This is my life's work. Sob. Hitch. Moan.
Ok, I didn't actually type sob, hitch and moan – but you bet your ass that's what I was doing when I wrote the ticket. Within 2 minutes, I had a response by way of email:
You may login to your Reseller Account and request a restore from the Product options. The price of a restore is $50.
Sure enough… I go to the products page and there, in all its glory, is the icon to request a restore from backup. The simple form asks for which date you wish to use and to also enter any applicable information. I simply write the database name and ask them to restore it from the latest backup they have.
Within 20 minutes my site was back up minus my 2 latest posts. I quickly reassembled those posts from email (where I subscribe to my own feed) and my site is back up 100%. I also missed out on 1 comment (sorry Jason!).
I'd been with this host for a long time now. Now I'm with Flywheel and automated nightly backups are part of their offering.
If I had one complaint, it's that after the ticket is closed you have no means of communicating with them about it. I wish you could add a comment to a closed support ticket.
Today it would have said, “Thank You!”.