With the privacy changes rolling out in Europe, and my forums having probably 10,000 members who no longer use it, I want to run a script to delete all private messages before 2018. That reduces my exposure to privacy issues.

Is there a simple way for me to prune out old private messages? The private_messages_posts backup file is nearly 60mb in size so I've got a few in there.

Can I select from private_messages_topics to get IDs before 2018 then delete those from users, posts, and then topics?

Thanks.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts