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?