How I Lost All My WordPress Data And How I Got It Back
- Updated On 05/07/2017
- Author : Anshul Tewari
- Topic : WordPress
- Short URL : https://hellboundbloggers.com/?p=17265
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.
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.
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?
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.
YOU CAN ALSO SEARCH FOR YOUR DESIRED TOPICS:
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.
- Facebook Comments
32 CommentsFacebook Comments