How remove one million of threads?

[Concha]

I want remove one million of threads and 2 million posts.
These threads are in one forum.

What is the best form to remove this?

[snakes1100]

Simply deleting the forum via the "forum manager" will do what you want, but with that many threads/posts in it, im going to guess you will have a few timeout issues, your going to have to change a few settings via php & mysql to get around the timeouts.

[ForceHSS]

snake beat me to it was just going to say that myself

[Concha]

Originally Posted by snakes1100

Simply deleting the forum via the "forum manager" will do what you want, but with that many threads/posts in it, im going to guess you will have a few timeout issues, your going to have to change a few settings via php & mysql to get around the timeouts.

Originally Posted by ForceHSS

snake beat me to it was just going to say that myself

What is specifically that option?


this?
thread.php?do=prune

[snakes1100]

Any timeout settings via php or mysql.

Most likely memory settings as well.

Without running it myself, i cant say what all errors you will run into, most likely, you will run into some more mysql errors unrelated to timeouts anyways.

Are you doing this because you think its causing server issues?

[Concha]

Originally Posted by snakes1100

Any timeout settings via php or mysql.

Most likely memory settings as well.

Without running it myself, i cant say what all errors you will run into, most likely, you will run into some more mysql errors unrelated to timeouts anyways.

Are you doing this because you think its causing server issues?

Is a cleaning, because are message from bots and spammers.

All threads are in one ID Forum.

What is the option in admincp?

[snakes1100]

There is no option in the admincp to change php or mysql settings, those are system programs.

As stated in the earlier post, you can try deleting the forum via the "forum manager", but its most likely going to error out with that many threads/posts in it.

[Concha]

Originally Posted by snakes1100

As stated in the earlier post, you can try deleting the forum via the "forum manager", but its most likely going to error out with that many threads/posts in it.

And delete these thread with phpmyadmin?

[snakes1100]

No, you cant do that.

Remove it as stated previously.

[Concha]

Originally Posted by snakes1100

No, you cant do that.

Remove it as stated previously.

Ok. But my question is, where delete these threads in admincp of vbulletin?

admincp/thread.php?do=pruneedit
admincp/thread.php?do=prune
admincp/other?


Thanks!!