PDA

View Full Version : copy specific thread from different db


hichew
01-30-2006, 09:43 PM
is it possible to copy a thread from my old forum ( same version 3.5.3 ) to my current forum ( it's from 2 different database table )

DrewM
01-30-2006, 09:49 PM
um.. I don't know how but I do know how to move all the threads.

Billspaintball
01-30-2006, 11:10 PM
Have all the user IDs of the posters remained the same or are they different between both databases?

hichew
02-04-2006, 06:02 PM
Have all the user IDs of the posters remained the same or are they different between both databases?

yes all remain the same.
actually i want to recover the thread that had been prunned 5 months ago.

Billspaintball
02-05-2006, 03:53 AM
In short is possible but its very hard.

Ive been looking at something similar for different reasons.If you have reindexed your database in the meantime however, you can forget about it.

From what I can work out you need to grab data from at least 3 different tables.

Im taking a different approach to just importing all the data, its too hard.
Im writing a script for a form so I can just imput the data into the form and submit it via vB's datamanager which will do all the hard work for me.
Naturally, it will be able to insert as whatever user you choose, and also use whatever timestamp you choose.
Of course, this means I can do only one record at a time, but since I dont have too many to do, it does not really worry me.

I havent had time to work on this lately, could be a week or two before I finish it.