playing with backup database

  • I have a general query when it comes to the MySQL database which stores all the important WP posts/comments etc.

    I do backup of my database quite often, and occasionally I take a peek at the txt file just to see how it’s all looking.

    I have noticed within the “Dumping data for table wp_comments” quite a lot of spam – spam which is not visible in my WordPress. I have gone through every single post in my WP to check for these comments but they don’t seem to exist – however in my PHP admin they are right there, and they are approved.

    All this blabbering has a point, and even a question – is it safe for me to remove these comments from the database by using myPHPadmin, or will it break something? I’m a bit of a neat freak when it comes to my files, so I would like to remove this spam, but not at the expense of breaking something…

    can someone advise?

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

  • Yes, if there are comments identified as SPAM by WP, then it will remain in your database but not be visible on regular posts.

    You can go to your Admin section and then Manage->Comments and click the link that says “only spam” which will show you all the spam in red. You can then enter “Mass edit mode” click all the spam and delete it.

    You can also delete it in the database directly using phpMyAdmin, but doing it through WP is easier. ??

    Regards

    It shouldn’t break anything, though you might want to look at coldforged plugin that allows you to whack spam-tagged comments from the comfort of your admin interface.
    https://www.coldforged.org/paged-comment-editing-plugin/

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘playing with backup database’ is closed to new replies.