PDA

View Full Version : Copying certain tables to new DB


Sooner95
08-03-2005, 08:56 PM
Ok, I don't even know if this can be done, I think it can tho..

He's what I have set up

My old board 3.03, SQL DB is good to go ect..

New board, currently 3.5 rc1, clean SQL DB

What I want to do, if possible, is to be able to save the posts, and users in the old DB and put them in the new DB. Even possible the Forums as well.

Now, I tried to do this lastnite and was able to Copy over certain tables and for the most part it worked ok. I did the forums first, tho the forum structe wasnt there on the new board. I did the sam with the posts and threads. and in the one forum that was there, you could see ther posts. So it did work, kinda.

I did end up woth a ton of sql errors, as to be expected. Not to worried about it, I can easily scrap it all and reinstall vb and create new db.

Anyone have exp with this? Know of a step by step tutorial that can walk someone like me thru it?

I'd appreciate any help, as I don't want to use the OLD Db anymore, way over hacked ect.. but would like to be able to save some of the info.

If possible.

as always, TIA

Marco van Herwaarden
08-03-2005, 09:08 PM
Use ImpEx (downloadable from member area at vb.com) to copy your old board to a new DB (you will be using 3.0.8 or even clean 303 first), then upgrade to 3.5

Sooner95
08-03-2005, 09:44 PM
Ah, that's what that is... ok..

In using the ImpEx, are you able to copy over certain tables? or just the whole db?

Marco van Herwaarden
08-04-2005, 03:24 AM
You make a fresh copy of all relevant vB data (new added tables/columns will be ignored) like users, forums and posts. Of course you can delete whatever you don't want afterwards.