I have had bbPress installed on my website for sometime. However, without me realizing it, thousands of spam comments and messages have been posted on the few forums I have made. I had thought that Akismet was supposed to be cleaning things up, but I guess not. Now, it’s gotten to the point that my WordPress database has ballooned to over 8GB and my hosting provider wants me to fix it or they will take my site down.
That being said I have been trying to find a solution and thus far have come up empty handed. The problem is no matter how hard I try to delete the comments, both from the bbPress plugin on WP-Admin or by deleting the records from myPHPAdmin, the server locks up and the task cancels. I guess the server is not powerful enough for such a task. So, I downloaded a copy of the database to my local machine to try editing it there, and in this case I can’t find an app that can open .sql files and when I do there isn’t enough memory to open it.
Are there any other solutions? Is there a way to shrink the SQL database before opening it? How about splicing it into smaller batches? Is there a specific app, preferably free, that does a better job at managing large SQL databases?
Thank you for the assistance! I was able to upload the plugin to my site and remove all of the comments and replies from the wp_post table in the database. Now, how do I remove their 8,150,308 orphaned post meta data from my database?