Title: Problems with wp_comments table
Last modified: September 25, 2025

---

# Problems with wp_comments table

 *  Resolved [kenmac54](https://wordpress.org/support/users/kenmac54/)
 * (@kenmac54)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/problems-with-wp_comments-table/)
 * I needed to migrate my website due to a hosting upgrade.
 * As part of the process I had to reduce the size of the WP database. I chose to
   export then delete the wp_comments table.
 * Now that the site is running in its new environment, I imported the wp_comments
   table but things aren’t working properly. My posts are still showing the correct
   number of comments but the comments are missing. Also, no-one can post new comments.
 * I fear that I might have broken some kind of internal link but I have no idea
   how to fix it.
 * Any ideas?
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fproblems-with-wp_comments-table%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Moderator [threadi](https://wordpress.org/support/users/threadi/)
 * (@threadi)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/problems-with-wp_comments-table/#post-18656281)
 * By deleting the wp_comments table, you have also deleted all comments. I would
   recommend:
    - Either importing the exported backup of the table again.
    - Or importing a backup of the entire project, which will also restore it.
 * Why did you decide to delete this table? It is part of the WordPress core and
   must always be present.
 *  Thread Starter [kenmac54](https://wordpress.org/support/users/kenmac54/)
 * (@kenmac54)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/problems-with-wp_comments-table/#post-18656523)
 * As I said, I needed to get the database under 1gb. I thought that export/delete/
   import would have worked.
 * Now, of course, I know different.
 *  Moderator [threadi](https://wordpress.org/support/users/threadi/)
 * (@threadi)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/problems-with-wp_comments-table/#post-18656699)
 * I would recommend cleaning up the database with a tool such as [https://wordpress.org/plugins/wp-optimize/](https://wordpress.org/plugins/wp-optimize/).
   But make sure you create a backup first.
 * If that’s not enough and the hosting limits are insufficient for your project,
   you should look for another hosting provider.
 *  Thread Starter [kenmac54](https://wordpress.org/support/users/kenmac54/)
 * (@kenmac54)
 * [8 months, 2 weeks ago](https://wordpress.org/support/topic/problems-with-wp_comments-table/#post-18656809)
 * Thanks all for your responses.
 * Unfortunately it was user error. I was looking at the migrated site rather than
   the new site. Once I discovered the error of my ways, I restored wp_comments 
   to the correct place and all is good.
 * SORRY FOR WASTING ANYONE’S TIME

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

The topic ‘Problems with wp_comments table’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 3 participants
 * Last reply from: [kenmac54](https://wordpress.org/support/users/kenmac54/)
 * Last activity: [8 months, 2 weeks ago](https://wordpress.org/support/topic/problems-with-wp_comments-table/#post-18656809)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics