How to delete 200 000 soft deleted messages?

[NorthFighter]

How to delete 200 000 soft deleted messages? Try to use Soft Deleted Archive, but it can't delete more then 100 messages in one pass.

[Infopro]

Have you tried the Prune Threads manager?

[ferreo]

This is a very time and resource consuming process and will most likely hang your browser - or your sql server will time out. I'd find a terminal way to go about it.

[NorthFighter]

This is a very time and resource consuming process and will most likely hang your browser - or your sql server will time out. I'd find a terminal way to go about it.

Show me the way.....I have root login to server and mysql server.
I just need sql query to delete soft deleted messages.

[NorthFighter]

Have you tried the Prune Threads manager?

Yes, I used it when I need to delete Threads, but now I need delete messages not threads.

[Lats]

Backup first...

DELETE FROM
    post
WHERE
    visible = 2
AND
    parentid > 0

[NorthFighter]

Backup first...

DELETE FROM
post
WHERE
visible = 2
AND
parentid > 0

Great thanks