OK Here is the problem. My board was updated from 1.4.4 to the first PRE-RC1 of 2.0.. then RC2, RC3, RC4, then Final. So it went through a lot of changes. Due to the fact that I have 1,000 registered users, not about to dump the entire database.
Anyways, the issue is -- I pruned the topics when it was around 100,000 total posts on the board. It did removed it visually from viewtopic.php , but the database still has all the post data (posts, and posts_text).
Now I am up near 60,000 posts on the forum again, totalling near 160,000+ posts worth of data in database.
I need to run a MYSQL command line string to delete posts OLDER than a certain date (say March 3rd, 2002) and make it only specific to Forum number 1 (viewforum.php?f=1
). That is the forum which takes up 90% of the board, all the other forums are archived type of forums I dont want to lose any posts.
If anyone can help, Thank you.
Here is the forum by the way-----