The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Copying Data from one forum to another
Hi All,
We're currently involved in migrating one forum to another existing (but empty) forum. The source forum is messy and cluttered with useless plugins etc and the destination is clean and fully setup. We'd like to copy the user, post and thread data over to the new forum without breaking anything. I'd like to know which database tables do I need to copy over to get all of this data in so that the users see a transparent transition? Any ideas? Kind Regards - Trev |
#2
|
||||
|
||||
Quote:
The best way to do it would be to use a third db, temporarily created, to store the tables exported from the original which the final db has. Then for each table in the final db run a describe <table name> query on the table then remove any extra fields from the temporary db's version of the table. Once you've done that for all tables export from the temporary db and restore it to the final db. |
#3
|
||||
|
||||
This is what's going to trip you up, you'll want to remove any/all plugins before trying to copy tables over since most plugins will make new fields in your columns.
|
#4
|
|||
|
|||
Thanks guys, I'll get on it
Kind Regards - Trev |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|