RSS Feed/News How I Purged old Conversations in database

[ENXF NET]

I simply picked a conversation ID that was in the timeframe I wanted and executed this query. In this case the id was 17783.

DELETE FROM databasename.xf_conversation_message WHERE (conversation_id <= '17783');
DELETE FROM databasename.xf_conversation_master WHERE (conversation_id <= '17783');
DELETE FROM databasename.xf_conversation_recipient WHERE (conversation_id <= '17783');
DELETE FROM...

Read more

Continue reading...