Problems with wp_comments table

  • Resolved kenmac54

    (@kenmac54)


    8 months, 2 weeks ago

    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 to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator threadi

    (@threadi)

    8 months, 2 weeks ago

    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

    (@kenmac54)

    8 months, 2 weeks ago

    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

    (@threadi)

    8 months, 2 weeks ago

    I would recommend cleaning up the database with a tool such as https://ww.wp.xz.cn/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

    (@kenmac54)

    8 months, 2 weeks ago

    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.