Title: all comments missing
Last modified: August 19, 2016

---

# all comments missing

 *  [stan747](https://wordpress.org/support/users/stan747/)
 * (@stan747)
 * [16 years, 9 months ago](https://wordpress.org/support/topic/all-comments-missing/)
 * On a site (WordPress 2.8.2) I was receiving strange empty comment moderation 
   requests:
 * > A new comment on the post # “” is waiting for your approval
   > Author : (IP: , )
   >  E-mail : URL : Whois : [http://ws.arin.net/cgi-bin/whois.pl?queryinput=](http://ws.arin.net/cgi-bin/whois.pl?queryinput=)
   > Comment:
   > Approve it: (blanked)
   >  Delete it: etc.
 * As I logged in I decided to upgrade to WordPress 2.8.4 and I also upgraded the
   plugins without any problems.
 * Only then did I take a look at the comments.
 * The “Posts” tab showed the number of comments for every post but the “Comments”
   tab showed 0 comments.
 * In fact all my comments were lost.
 * I went to check the database with phpMyAdmin and looked at the table
    “wp_comments”.
   It had reportedly crashed.
 * I do not have much experience with databases and such but I decided to drop the
   table and replace it with a backup.
 * From my backup .sql file I copied the part:
 * # ——————————————————–
    # Table: `wp_comments` # ——————————————————–
 * until:
 * #
    # End of data contents of table `wp_comments` # ——————————————————–
 * Then I ran this SQL code in phpMyAdmin which restored the comments in my blog.
 * I have no idea if it is caused by a hacker, an error in the hosting or an error
   in WordPress or the upgrade.
 * I wonder if anyone has had a similar experience. Just wanted to share this so
   it may help you one day.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [N4wzaFDsjlbO](https://wordpress.org/support/users/jacobbrett/)
 * (@jacobbrett)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/all-comments-missing/#post-1209190)
 * I just noticed the same thing on my website. :S
    Odd, the comments are in my 
   db, but aren’t showing up in WordPress…
 *  [N4wzaFDsjlbO](https://wordpress.org/support/users/jacobbrett/)
 * (@jacobbrett)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/all-comments-missing/#post-1209191)
 * Sorry for double post; additionally, the spam comments from the same table show
   up.
 *  [nkhayes](https://wordpress.org/support/users/nkhayes/)
 * (@nkhayes)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/all-comments-missing/#post-1209192)
 * I’ve lost my comments, too. And, of course, I didn’t do the backup prior to upgrading.
 * Is there a way to get them back?

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘all comments missing’ is closed to new replies.

## Tags

 * [Comments](https://wordpress.org/support/topic-tag/comments/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 3 participants
 * Last reply from: [nkhayes](https://wordpress.org/support/users/nkhayes/)
 * Last activity: [16 years, 7 months ago](https://wordpress.org/support/topic/all-comments-missing/#post-1209192)
 * Status: not a support question

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics