for my wordpress site i am cleaning my database from spam, which were somehow inserted there, but my site is working regardless. i opened phpmyadmin, and saw sam in wp_posts… so in phpmyadmin i open the table, go to the tab that says browse, go over the posts one by one, find spam posts and just hit delete and those posts are physically removed right?
but what about the table called wp_postmeta? dont all the possts in wp_posts have a corresponding entry in wp_postmeta? if so , if i delete spam posts from posts table will it be a problem or it is ok?
even if it is ok, the meta for the spam post will still remain in postmeta table if i delete just the post from wp_post. so is there a better way to clean faster and both? i didnt touch anything yet. i want to know first