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]

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.

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]

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]

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]

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!!

[snakes1100]

Via the forum manager, delete the forum that they are in.

Trying to prune them off like that would take you week(s) depending on your server settings.

[Concha]

Via the forum manager, delete the forum that they are in.

Trying to prune them off like that would take you week(s) depending on your server settings.

WOW, Just deleting the forum that contains all these issues will clear all.
admincp/forum.php?do=modify

Many thanks

[snakes1100]

Yes, it will remove them.

If it doesnt timeout.

[Chris8]

Are those spam threads or real user created content? Because if those or real user created posts/threads and public perhaps it is a better idea to keep them and monetize them with e.g. Google ad-sense, no? I believe 1mln threads would bring a few $k/monthly whatever the subject of those threads is.

Anyway, you might find this helpful -> https://vborg.vbsupport.ru/showthread.php?t=223716

[Concha]

Are those spam threads or real user created content? Because if those or real user created posts/threads and public perhaps it is a better idea to keep them and monetize them with e.g. Google ad-sense, no? I believe 1mln threads would bring a few $k/monthly whatever the subject of those threads is.

Anyway, you might find this helpful -> https://vborg.vbsupport.ru/showthread.php?t=223716

spam :(