Make Money Online Queries? Struggling To Get Traffic To Your Blog? Sign Up On (HBB) Forum Now!

How I Lost All My WordPress Data And How I Got It Back

CONNECT WITH HBB ON SOCIAL MEDIA

One of the things that bloggers and website owners continuously do is optimize their site for a better load speed. For a good user experience, one needs to have a site that loads faster and does not lead to the user running away. Not only is this bad for your readership, but your Google rankings are affected drastically, your bounce rate goes up, and the Alexa rankings get affected. Moreover, it could lead to low ad revenues.

Losing My WordPress Data

My website speed was slow, and I wished to optimize the same. After reading about 30 posts on how to do this, I removed plugins, I optimized by the database, I reduced the HTTP requests, but still, I wasn’t satisfied with the results, so I went into the phpMyAdmin of my site and decided to delete the unused tables.

How I Lost All My WordPress Data And How I Got It Back

Now I am not a techie, but with whatever fair amount of knowledge I had about PHP and WordPress I deleted a few tables and went back to check my blog and what came forward was shocking. I felt I had lost everything and was ready to do anything to rectify my mistake.

I had deleted one of the critical database files, the one that had all the data, all posts, all comments, all tags, everything &dmash; and I was broken. A blog I had spent three years on, built it like a baby, got a decent readership, made it into a company, was all gone. Everything blasted. YouthKiAwaaz had almost 2000 posts, 12000 comments, 6000 tag — all lost.

How I Solved This Problem & Restored it

So what next? I had a quick call with my host, and I was told that there is no solution. After looking up Google and being heart broken for about 2 hours, I found a solution. Thankfully, I was using a backup plugin and used to do weekly backups. This incident took place on the 12th Jan, and my last backup was on the 7th Jan. I quickly contacted my hosting company again and asked them to fix it, to upload my SQL database as of the 7th — and thankfully it all fell into place. I had lost all my data published between the 7th and the 12th, but thanks to Feedburner email service, I had it all in my email. It took a night, but I uploaded all the data, and I was up and running.

READ
12 WordPress Plugins To Enhance Your Blog's Performance

This was probably one of the biggest learning for me, and I wish to share a few highlights with you here. Your blog is your baby — treat it like one. Make sure you are taking regular backups. Earlier I used to take weekly ones, but since this incident, I am taking daily backups and making sure that I save the key data of my blog.

You must also ensure that you have an excellent, helpful host, with immediate customer service, like I had. The host helped me a lot in finding out what the problem was.

Am sure you would not do something I did — delete your own tables, but you never know when your blog would go down and when you would need to reload everything — it  could be a server attack, a spam, a WordPress attack, or anything.

A backup can be your savior, and as a professional blogger, I recommend you to take daily back ups. Have you had any such experiences? What do you think?



By

Anshul is the Founder and Editor-in-Chief of YouthKiAwaaz.com, which is a World Summit Youth Award 2010, awardee online platform for the youth to express themselves on issues of importance. He loves gadgets and development journalism is his forte'. When he is not working he is watching Ray William Jhonson on YouTube.

Want to discuss your queries and interact with experts? You can connect with HellBound Bloggers (HBB) Facebook group for free!

Join HellBound Bloggers (HBB) and get Instant Updates. We'll also notify you with Great Deals, Discounts and other Interesting Tips. We won't SPAM or SHARE your Email Address with anyone.

Thank you for reading! We welcome and appreciate your comments, but at the same time, make sure you are adding something valuable to this article. If you have any serious queries, suggestions or anything related to this article, feel free to share them, we really appreciate that.

But, if your blog comments are a random "Thank you", "Useful Post", or anything that doesn't actually upscale the article, then we'll be removing them and it won't be appeared below. Thanks for understanding and thanks for connecting with us. If you want to give us any feedback or report any errors, you can kindly contact us and we'll revert back soon.

  • Comments
  • Facebook Comments
More in WordPress
5 Worthy AJAX Plugins To Enhance WordPress Comments

Close