Skip to main content

How to recover deleted wordpress database without having backup?

Hi All, You might have noticed that my blog was down due to database error some days before. In this post, I would like to share How I recovered all my deleted pages, posts and comments without having a backup file.

What happened was that I just deleted my wordpress database accidentally. Suddenly it is gone. Though images, themes, plugins and other data getting saved in Hosting file management, WordPress usually store all the settings, posts, comments data in WordPress database in a server.

Usually We need to take a backup of whole website using backup or backup-wizard given in the cpanel, which will have .sql file if unzipped. With that file we may use import section of ‘PhpMyAdmin’ and run it for backing up the deleted database.

But in my case i have lost that backup folder also.

But in luck, Every week I usually submit my website to Google for indexing. Like the same before I have submitted my sitemap to Google last week.

Thank God! Google had the cached copy of my entire wordpress site.

How To Recover

I have created another database for wp in ‘PhpMyAdmin’, and assigned a user with ‘password’. Then In File Management of cpanel, I have opened ‘wp-config.php’ under wordpress installation folder.

Then I checked for the lines similar to below.

define('DB_NAME', '*****');

/** MySQL database username */
define('DB_USER', '******');

/** MySQL database password */
define('DB_PASSWORD', '******');

Then I replaced Database name near DB_NAME within quotes, Database Username near DB_USER within quotes, Database Password near DB_PASSWORD within quotes.

I just typed ‘site:http://bizgolive.com/blog/’

I got all the indexed pages listed down in Google.

how-to-recover-deleted-wordpress-database-without-backup

I just clicked the down arrow under listed link, It showed “Cached copy”. Clicked it.

Wow! All the post data is there. I just copied down my entire post, set up that specific date and “published”. Now new post data is entered into database.

Similarly For comments, every-time I will receive Notification from each visitor who comment on my post. I just checked out those comments and set specific date in database too for comments in ‘wp_comments’ table.

This way I have recovered my deleted wordpress database one by one without having backup file. Hope this will help you if you face the same problem just like me. Kindly leave a comment what problems and all You face and how did you recover your blog or If you need any help I will try to help you, Thanks!

52 thoughts on “How to recover deleted wordpress database without having backup?

  1. I just want to say I’m all new to blogs and really enjoyed this web-site. Probably I’m going to bookmark your site . You amazingly come with superb articles. With thanks for revealing your web site.

  2. Hi there, I discovered your site by the use of Google at the same time as searching for a comparable subject, your website came up, it appears good. I have bookmarked it in my google bookmarks.

  3. You really make it seem so easy with your presentation but I find this matter to be actually something that I think I would never understand. It seems too complex and extremely broad for me. I am looking forward for your next post, I will try to get the hang of it!

  4. A lot of of what you mention is astonishingly precise and it makes me wonder the reason why I had not looked at this with this light before. This article truly did turn the light on for me as far as this specific topic goes. But at this time there is actually 1 factor I am not too comfy with so while I try to reconcile that with the core theme of the point, permit me observe what the rest of the visitors have to say.Well done.

  5. It certainly is almost impossible to see well-updated visitors on this issue, nonetheless you appear like you understand which you’re writing about! Appreciate It

  6. Hello there, simply turned into concious of BLOGURL thru Yahoo, and found that the chances of informative. I? m gonna watch over for brussels. I will appreciate when you continue this in forthcoming. A lot of some others will be benefited within your writing. Cheers! NAME

  7. hi!,I like your writing so much! percentage we keep in touch more about your post on AOL? I need an expert in this area to unravel my problem. Maybe that’s you! Having a look forward to see you.

  8. I merely desire to show you that I am new to putting up a blog and completely adored your review. Likely I am likely to save your blog post . You undoubtedly have wonderful article information. Delight In it for telling with us your very own site information

  9. I do believe all the ideas you have introduced on your post. They’re very convincing and will certainly work. Still, the posts are very short for novices. May you please extend them a bit from next time? Thank you for the post.

  10. It happens to be appropriate opportunity to prepare some desires for the long run. I have browsed this post and if I have the ability to, I want to propose you couple of appealing pointers.

  11. You can definitely see your enthusiasm within the work you write. The sector hopes for more passionate writers such as you who aren’t afraid to mention how they believe. Always go after your heart. “Every man serves a useful purpose A miser, for example, makes a wonderful ancestor.” by Laurence J. Peter.

  12. Hi, i think that i saw you visited my website thus i came to “return the favor”.I’m trying to find things to enhance my web site!I suppose its ok to use a few of your ideas!!

  13. Thank you for sharing superb informations. Your website is very cool. I am impressed by the details that you’ve on this website. It reveals how nicely you perceive this subject. Bookmarked this web page, will come back for more articles. You, my friend, ROCK! I found just the information I already searched all over the place and just couldn’t come across. What a great site.

  14. You actually make it seem so easy with your presentation but I find this matter to be actually something which I think I would never understand. It seems too complicated and extremely broad for me. I am looking forward for your next post, I’ll try to get the hang of it!

  15. I loved as much as you’ll receive carried out right here. The sketch is attractive, your authored material stylish. nonetheless, you command get got an shakiness over that you wish be delivering the following. unwell unquestionably come more formerly again since exactly the same nearly very often inside case you shield this increase.

  16. My developer is trying to persuade me to move to .net from PHP. I have always disliked the idea because of the expenses. But he’s tryiong none the less. I’ve been using WordPress on a variety of websites for about a year and am anxious about switching to another platform. I have heard fantastic things about blogengine.net. Is there a way I can import all my wordpress posts into it? Any help would be really appreciated!

  17. I’m still learning from you, as I’m trying to achieve my goals. I certainly enjoy reading all that is written on your blog.Keep the aarticles coming. I enjoyed it!

  18. I have not checked in here for some time as I thought it was getting boring, but the last few posts are good quality so I guess I’ll add you back to my daily bloglist. You deserve it my friend 🙂

  19. Its like you read my mind! You seem to know so much about this, like you wrote the book in it or something. I think that you can do with some pics to drive the message home a bit, but other than that, this is great blog. An excellent read. I will definitely be back.

  20. This is very interesting, You are a very skilled blogger. I have joined your feed and look forward to seeking more of your wonderful post. Also, I have shared your website in my social networks!

  21. obviously like your website but you need to check the spelling on several of your posts. Many of them are rife with spelling issues and I in finding it very troublesome to inform the reality nevertheless I’ll definitely come back again.

  22. I’ve been absent for a while, but now I remember why I used to love this blog. Thanks, I’ll try and check back more frequently. How frequently you update your site?

  23. Merely a smiling visitant here to share the love (:, btw outstanding pattern .

    Trætrapper

  24. I’ve been browsing on-line more than 3 hours as of late, but I never found any fascinating article like yours. It is pretty price enough for me. In my opinion, if all webmasters and bloggers made excellent content as you did, the web will be much more helpful than ever before. “No nation was ever ruined by trade.” by Benjamin Franklin.

  25. Excellent blog here! Also your web site loads up fast!
    What host are you using? Can I get your affiliate link
    to your host? I wish my web site loaded up as fast as yours lol

  26. My partner and I stumbled over here different page and thought I might as well check things out. I like what I see so now i’m following you. Look forward to looking into your web page for a second time.

  27. Very good blog! Do you have any tips for aspiring writers? I’m hoping to start my own blog soon but I’m a little lost on everything. Would you recommend starting with a free platform like WordPress or go for a paid option? There are so many options out there that I’m totally overwhelmed .. Any suggestions? Many thanks!

  28. I have to show thanks to you just for rescuing me from this type of dilemma. Just after looking through the the net and coming across things which are not pleasant, I assumed my entire life was well over. Existing minus the strategies to the difficulties you’ve resolved through your blog post is a serious case, and those that could have badly damaged my career if I hadn’t discovered your web site. That talents and kindness in controlling all areas was vital. I don’t know what I would have done if I had not encountered such a step like this. It’s possible to now relish my future. Thanks so much for this skilled and sensible guide. I won’t be reluctant to endorse your web page to anyone who wants and needs tips about this subject.

Comments are closed.