Have you ever opened your blog to see everything gone? None of your posts will be visible only the empty Theme with Ads all around! I know you will get a shock of your life, and Even I did! Yesterday, when I opened my blog, I got a message “Nothing found” written in the posts section of my theme. I was just about to faint and was not understanding what exactly was going on. It was 2 years of my hard work perishing in just 1 second! There was nothing left.
I started searching Google on what might have caused it and How can I undo this change. But I dint find any relevant and helpful articles. Most articles talked about various such cases which have happened before. Even I had noticed such a case with a fellow blogger who blogs at “The Bad Blogger“. I wrote a comment on his blog but the reply never came anytime soon.[The comment got deleted too]
Then I logged in to FaceBook and started searching for Bloggers in my Friends list. I started chatting with 3-4 of them and explained them my problem. They were helpful but most of them dint have enough knowledge about this issue. Everyone asked me the same question “Do you have the back-up of your Database?” and my answer was “NO”! I was cursing myself for never taking a back-up of my WordPress Blog.
I was really depressed and tears were just about to flow from my eyes! Various thoughts were crossing my mind. “I have lost everything what I earned in the last 2 years”, “My Alexa rank of top 1,00,000 will be gone” and so on..
That was when I found “Piyush Kumar“, a FaceBook friend whom I had befriended the same morning, Online on FaceBook chat. I did not know that he was a blogger and I crazily send him a buzz saying “Help Needed”. He was quick to reply. I told him the exact problem of what had exactly happened and that I dint have the back-up of my database.
He though over it quickly and asked me weather I had access to the CPanel of my hosting provider and also to the PHPMyAdmin. I said yes! He asked me for the Username and the Password of my hosting provider and I gave it to him without even thinking over it. I had visited my database just before talking to him just to find out the “wp_posts” table in the database totally empty and corrupted.
Piyush had a look at it and told me that he may be able to get back the “wp_posts” table of the database. I was happy to hear it! I dont really know What he did, but I think he restored the database to the latest known stable one. The corruptness was gone. I had life back in my heart!
He asked me to take the back-up of the Database ASAP and I did exactly as he said! My blog was back in action. But when I refreshed my blog while backing-up the Database, I got an error saying “Error Establishing Database Connection”. I was so nervous and was about to cry! I tried to buzz Piyush, but he had gone Offline by that time. I also buzzed him on the Gmail chat, but he wasn’t there too. So, I nervously questioned on his Wall weather he was still Online? And within 2 minutes he commented on it saying “yep ! tell me..” It felt better to see him Online.
He told me that the error was because I was backing-up my database and So, the database was not able to connect with my Browser. My Blog started working fine again after the backup!
He asked me to change the Password of my database and Hosting account as he had know it. He appeared quite trustworthy, but still I did it and from then on “Error Establishing Database Connection” message was present on my blog for 17 hours! My mistake was that I changed the Database Password but dint change the password in the wp-config.php file. Now when I have done it, I am writing this post for saying thanks to Piyush Kumar for his Instant Help and Valuable suggestions.(Join Piyush on Facebook) I might have never got my Blog back without him!
Now all you guys, Please Back-up your WordPress Database first and then do all the other work! I just escaped the biggest disaster of my Blogging career but you may not be as lucky as I am. Take Care!