Friday, August 21, 2020

How I Lost All My Wordpress Data How I Got It Back

How I Lost All My Wordpress Data How I Got It Back 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 BackUpdated On 05/07/2017Author : Anshul TewariTopic : WordPressShort URL : https://hbb.me/2snDCUj CONNECT WITH HBB ON SOCIAL MEDIA Follow @HellBoundBlogOne 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 DataMy 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 wasnt satisfied with the results, so I went in to 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 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 itSo 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 pl ace 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.READThe Best WordPress Permalink Structure: Which One?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 somethin g 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?

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.