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

XF 1.4 Restoring a deleted users conversations

Warchamp7

Active member
#1
Due to an admin's error we lost one of our oldest users and I'm trying to restore what I can without digging into backups or cross referenced queries.

I got posts/thread data restored using the username column to relink their new accounts user_id. I'm currently trying to figure out the process for restoring conversations.

Looking at xf_conversation_user, I don't really have something concrete to work with here. Is this table generated though? Do I need to restore anything there?

Alternatively: Is there an elegant query I can use to dump conversation data for user_id 111 and then import into the production database into user 2222?
 

Mike

XenForo developer
Staff member
#2
There's a lot of complex and interlinked data here. Unfortunately, our recommendation is always going to be restoring from a backup.