XF 2.1 Export/import thread

[duderuud]

For reasons unknown a complete thread is gone on our production website. Also checked the db but the whole thread is really gone.

I still have the complete thread on our testserver (with the same settings/version of XF).
Does anyone have an idea on how to export that thread (with a db query?) and import it into the production db?

 

[klamm]

Same ... any ideas how to export/import a thread?

 

[Robert9]

1. You can do it manually.
2. You can install a backup forum on localhost and use a tool to synchronize.
3. You can install a backup forum on localhost and use the api (not tried, probably there is no insert_thread with id x,
so you need to write an add-on for this)
4. Write a small script opening both databases select and insert.


You can do it manually.
-------------------------------------
1. select the thread from db;
click export on screen

2. open the other db in another browser
use sql, add insert

3. do the same with posts

4. I have never cared for the attachments; but the way will be the same

5. Maybe there are more things like reactions, votes, whatever
then you have to find all the stuff that is connected to this thread, posts ...


I have found this thread, because i was looking for a solution; maybe it is time to solve this quest finally to have a tool for cases like this.
Maybe there is an add-on from AndyB to export a thread, but probably not for import.
And there must be an add-on from ozz to import a thread from a backup?

 

[Robert9]

[OzzModz] Post Message Replace From Backup

Requested by @duderuud Requirements: XF 2.2 Description: Adds rebuild tool that allows to restore post messages from backup table. Useful in case of unsuccessful bulk text replacement. CLI command...

xenforo.com

It is for posts, but if this works this would be very nice; then you need to select and insert the thread only;
and maybe this add-on cares for the rest? Might be it will fetch only the message_field?
Have not watched code ... sorry.