How Do I Mass Prune Threads using Command Line?
 

Hello,
Is there any way to mass prune threads from selected forums from command line?
I have near 5000K (5000000) threads to prune, but Admin CP option gives me memory outage error though I have 1GB memory allocated to PHP.

Thanks

Ouch,.... Do you have try to delete the threads via SQL? Think this is better for your memory.

What should be the query?

Well, if I do a DELETE from threads, it'll delete all the thread, but what about posts in those threads? Won't they left on database? :(

Hello,

try this one:
https://vborg.vbsupport.ru/showthread.php?t=275314

So make it step by step:
Delete all for 4 week
than
all from 8 week
and so on.

Thanks.. :)
But I have managed to do it using the default prune tool.
What I did is decreased the memory limit in php config and used 8GB memory using ini_set for thread.php file in admin cp.
Run the tool and waited for over 10 Hours.

Heavy ^^

Abhik, can you explain this in depth a little more? I need to delete 3/4 of my users, but when I try to delete more than a couple 10s of thousands my browser hangs.