Database Edit Question.. How Do I...

[Europeanlee]

Does anyone know if it is possible to take specific posts/threads from database1 and import them in to database2?

For example, lets say i have a board with 5 individual forums.

Can i take ONLY threads/posts from forumid=1 and import that information in to another forums SQL database?

[Marco van Herwaarden]

You could try using ImpEx for this:
1. Import from Board A to a temporary board
2. Remove unwanted forums/posts from temp board
3. Import from Temp board to board B

[Europeanlee]

Marco,

Thanks for the unfortunately, i dont think this is going to be an option due to having over 100,000 posts on the database i want to prune the threads/posts from.

Ill give it a go though to see if it will work for what i need :)

On the off-chance this doesnt work, do you know if it is possible to manually download the SQL tables and decompile the data contained within them?

[Marco van Herwaarden]

ImpEx will work for you.

Yes you could manually copy tables over, but it is a more complicated job then most people realize.