XF 1.4 Restoring a deleted users conversations

[Warchamp7]

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]

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