Valentine’s Day is a day which a lot of people get excited about. Though, my Valentine’s Day story was a little different, and I’m sure no one would want to have had the kind of date that I did.
I have been blogging in my native language since 2004 on a BlogSpot domain, and recently I started a technical blog called A New Tab.
I have some traffic, and my search engine ranking is getting better every day.
I had to update the path of the existing images. And to do that, there is a simple SQL query which I had to run at PHPMyAdmin.
I copied the query and executed it on my database. But I hadn’t noticed that there were some formatting errors (like extra spaces) while copying the query. Because of this, all of my image paths became corrupted.
While correcting these things, I lost my data.
And I realized that I had made the biggest mistake I have ever made:
- I didn’t take a backup of my WordPress blog.
I had written almost 40 posts. It seemed like all of that data was now gone.
I was out of options and turned to my hosting provider. I searched their site and found that HostGator offers regular backups for their clients.
This gave me hope.
What HostGator Did
It was 10:00 in the morning.
I emailed them asking when their latest backup was for my blog.
They replied in minutes saying that they had a backup which was two days old and would cost $15 for the restoration. Without hesitation, I replied for them to proceed.
After some time, I got an email from HostGator saying that they’d successfully restored my website. When I checked, I found they had restored my website, but from a backup that was 2 months old.
Immediately, I logged into the live chat with HostGator’s customer support to tell them about the issue. They apologized for what happened and said they would try to restore it as soon as possible. I waited for around 2-3 hours, talked to another customer support agent, and sent a few extra emails to the customer service team. They all said they were “working on it”.
I spent a lot of time worrying…
Finally, after 13 hours, at 11:00 PM, I got a reply from them saying that they had failed to restore my site.
They were only able to restore my site to the original 2 month old backup. I was pretty annoyed. I thought about all the time I wasted dealing with HostGator.
How I Restored
I checked my blog, and all of the posts had titles, but they didn’t have content. I went into my email and found all of my posts (because I’m subscribed to my blog). I copied the content from the emails and posted them back onto my site.
It took almost 5 hours, but eventually, by Feb. 15, I got everything back.
But I had missed Valentine’s Day.
- Take a backup before doing any experiment or customizing.
- Don’t depend on the web host for a backup; even though they may be the world’s #1 hosting provider, they may fail.
- Don’t experiment on Feb. 14 (Valentine’s Day) and forget about your girlfriend… :-)
Note: I am not saying anything bad about HostGator. I love HostGator, and I have almost 10 sites with them. But I am saying that it’s ultimately you who is responsible for taking a site backup.
Are you taking timely backups of your blog? Have you ever faced anything like this before? Let me know in the comments below!