How Do I Mass Prune Threads using Command Line?

[Abhik]

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

[Kraxell]

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

[Abhik]

Originally Posted by Kraxell

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

What should be the query?

[Abhik]

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?

[Kraxell]

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.

[Abhik]

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.

[Kraxell]

Heavy ^^

[zylstra]

Originally Posted by Abhik

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.

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.