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:’

I got all the indexed pages listed down in Google.


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. Simply wanna comment that you have a very nice website , I the design it really stands out.

  7. It’s actually a nice and useful piece of information. I am happy that you just shared this helpful information with us. Please keep us up to date like this. Thank you for sharing.

  8. I conceive this web site holds some rattling excellent info for everyone :D. “Do not go where the path may lead, go instead where there is no path and leave a trail.” by Ralph Waldo Emerson.

  9. I conceive you have observed some very interesting details , thanks for the post.

  10. I really appreciate this post. I have been looking everywhere for this! Thank goodness I found it on Bing. You’ve made my day! Thanks again!

  11. 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

  12. 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.

  13. Rattling nice style and design and fantastic articles , very little else we need : D.

  14. 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

  15. 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.

  16. 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.

  17. 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.

  18. 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!!

  19. I like what you guys are up too. Such clever work and reporting! Keep up the excellent works guys I have incorporated you guys to my blogroll. I think it will improve the value of my site :).

  20. You made some good points there. I did a search on the topic and found most people will go along with with your site.

  21. It is actually a great and helpful piece of info. I am satisfied that you simply shared this useful information with us. Please stay us informed like this. Thanks for sharing.

  22. 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.

  23. 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!

  24. 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.

  25. 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 Is there a way I can import all my wordpress posts into it? Any help would be really appreciated!

  26. 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!

  27. fantastic points altogether, you simply won a brand new reader. What may you recommend about your publish that you made a few days in the past? Any positive?

  28. 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 🙂

  29. Generally I don’t read post on blogs, however I wish to say that this write-up very compelled me to try and do so! Your writing style has been surprised me. Thank you, very great article.

  30. Merely a smiling visitor here to share the love (:, btw outstanding design .

  31. 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.

  32. Only a smiling visitant here to share the love (:, btw great style and design .

  33. Great website. Lots of helpful info here. I’m sending it to several buddies ans additionally sharing in delicious. And obviously, thanks on your sweat!

  34. 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!

  35. 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.

  36. 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?

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


  38. Excellent website. A lot of useful info here. I’m sending it to a few buddies ans additionally sharing in delicious. And of course, thanks in your effort!

  39. 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.

  40. I truly appreciate this post. I have been looking all over for this! Thank goodness I found it on Bing. You have made my day! Thx again!

  41. Hi, Neat post. There’s a problem together with your website in internet explorer, could check this… IE still is the market leader and a good part of other people will leave out your fantastic writing because of this problem.

  42. Usually I don’t learn article on blogs, but I would like to say that this write-up very pressured me to try and do it! Your writing taste has been surprised me. Thanks, very nice post.

  43. 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

  44. 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.

  45. 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!

  46. 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.

  47. As soon as I observed this web site I went on reddit to share some of the love with them.

Comments are closed on posts more than 30 days old. Got a burning question? Head to our Recent Post to start a new conversation.