1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'XenForo Questions and Support' started by Jamie, Nov 21, 2010.

  1. Jamie

    Jamie Well-Known Member

    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.

  2. Blandt

    Blandt Well-Known Member


    Empty the content of those tables
  3. Blandt

    Blandt Well-Known Member

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

    Jamie Well-Known Member

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

  5. Elizabeth

    Elizabeth Well-Known Member

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

    Blandt Well-Known Member

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

    Jamie Well-Known Member

    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!


Share This Page