Is there a way to delete all PM's from one user via a SQL statment?

[Jamie]

I have always kept all PM's that I thought were important, but with that number pushing 600, I would like to prune them.

When I imported, it marked everything as new, which isn't ideal, so now I am looking for a way to remove just my PM's.

I have already ran a SQL update to mark them as read as far as the Inbox Alerts goes, but I would like to delete them at this point.

Thanks for any help with this.

Jamie

 

[Blandt]

xf_conversation_master
xf_conversation_message
xf_conversation_recipient
xf_conversation_user

Empty the content of those tables

 

[Blandt]

You use phpmyadmin to empty the tables or run this query
DELETE * FROM [table_name]

 

[Jamie]

Wouldn't that delete all PM's? I am looking for only delete my PM's.

Jamie

 

[Elizabeth]

You could save the sql file to your hard drive, delete your's carefully and then reinsert the sql file.

 

[Blandt]

Wouldn't that delete all PM's? I am looking for only delete my PM's.

Jamie

Hmmm I really thought you wanted to prune all of them so yes .. look for your ID and empty your tables only (recipient and message)

 

[Jamie]

Ah ok.. I thought it would be that when you said purge those tables, I thought to myself, what if I just did it to the userid 1.

Thanks, I will give that a go on my test site!

Jamie