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.