How to import from a dump file

[Wachtmeister]

Guys...

I've imported two databases from the same host to my vb3 system.

Now i wanted to import my last system from another host, what wasn't successful, because remote connections are not allowed.

So i dumped the database to a file (i hope, i did it right).

I've then set my vBulletin:Impex Config File to the following:


;vBulletin:Impex Config File<?php /*
;|
[ Target Database ]
; The following settings allow ImpEx to connect to the vBulletin 3
; database into which you will be importing data.
targetdatabasetype = mysql
targetserver = localhost
targetuser = user
targetpassword = pw
targetdatabase = dbase
targettableprefix = vb3_
[ Source Database ]
; If the system that is being imported from uses a database,
; enter the details for it here and set 'sourceexists' to TRUE.
; If the source data is NOT stored in a database, set 'sourceexists' to FALSE
sourceexists = FALSE
//sourcedatabasetype = mysql
//sourceserver = ip
//sourceuser = root
//sourcepassword = pw
//sourcedatabase = dp
//sourcetableprefix = phpbb_
;| ################################################## ################## |;
;| # File ends with closing PHP tag... # |;
;| ################################################## ################## |;
;*/ ?>


The import screen appears and i can click some buttons, but noone asks me ever for the dump file? What do i have to do with the dumped file? Maybe the question is a bit stupid, but i have really no idea ;(

Can someone help?

Regards, Wachtmeister

[Zachery]

You commented out half the conifg
If the database has been restored you need to change sourceexists to TRUE and enter the correct info that is NOT commented out
sourceexists = TRUE
sourcedatabasetype = mysql
sourceserver = ip
sourceuser = root
sourcepassword = pw
sourcedatabase = dp
sourcetableprefix = phpbb_

[Jerry]

Are you importing 2 diffrent boards into a third vB3 one ?

I.e. A + B into C ?

[Wachtmeister]

You commented out half the conifg
If the database has been restored you need to change sourceexists to TRUE and enter the correct info that is NOT commented out
sourceexists = TRUE
sourcedatabasetype = mysql
sourceserver = ip
sourceuser = root
sourcepassword = pw
sourcedatabase = dp
sourcetableprefix = phpbb_

So i have to restore the dump file into my localhost database first? And after that, i have to import it the old way? It even didn't worked with the now outcommented strings. I really do not understand the way to import...

[Wachtmeister]

Are you importing 2 diffrent boards into a third vB3 one ?

I.e. A + B into C ?
Yes, i imported two phpbb systems into my existing vb3. And now i want to import the third phpbb into this existing vb3. So i made 3 forums to one.

But i cannot import the database from the remote system.

[Jerry]

Currently this shouldn't work to be honest, because the board you are importing into has import*id's in all the tables. (i.e. importuserid, importthreadid, etc) As it is there is no clean up function.

You must of set them all to 0 to do import number 2 & 3 ?

[The Quibbler]

Um... I was planning on importing two boards into an existing vb one, as well. I guess this is going to give me problems? Any way to get around it?

[Steve Machol]

No, there is currently no option to do this.

[Jerry]

Um... I was planning on importing two boards into an existing vb one, as well. I guess this is going to give me problems? Any way to get around it?

The vB3-> vB3 importer is about 50% done, I'm working on it and the OT one currently.