Impex, phpbb conversion question.

[thenewuser]

I wish to convert a phpbb2 databse on one of my other sites to my new vB site. However it's not working out, tell me if this config is looking correct.

;vBulletin:Impex Config File<?php /*
;| #################################################################### |;
;| # vBulletin - Licence Number <removed>
;| # ---------------------------------------------------------------- # |;
;| # Copyright &#169;2000–2005 Jelsoft Enterprises Ltd. All Rights Reserved. |;
;| # This file may not be redistributed in whole or significant part. # |;
;| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # |;
;| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # |;
;| #################################################################### |;

[ Target Database ]
; The following settings allow ImpEx to connect to the vBulletin 3
; database into which you will be importing data.
;
; If impex is installed in vBulletin you can ignore the target details
; as includes/config.php

targetdatabasetype = mysql
targetserver = localhost
targetuser = "username"
targetpassword = "password"
targetdatabase = vb.
targettableprefix =

[ 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

; mysql OR mssql
sourcedatabasetype = mysql
sourceserver = www.site1.org
sourceuser = "username"
sourcepassword = "password"
sourcedatabase = dbforum
sourcetableprefix = phpbb_

;| #################################################################### |;
;| # File ends with closing PHP tag... # |;
;| #################################################################### |;
;*/ ?>

Of course I took out the usernames and whatnot, I'm thinking that in line:

sourceserver = www.site1.org

Maybe this is not how I write this up?
Also here:

targettableprefix =

I don't think vB has a prefix, it doesn't seem to when I installed it anyway.

I basically want to import the DB from site 1 to site 2...

[thenewuser]

This is the error I recieved:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /impex/db_mysql.php on line 248

[aelion]

First, I don't think you should try to import directly into 3.5 until Impex has been updated to 3.5. The way to go about it is to install 3.07 and do a trial run import after you backed everything up. Then do it for real once you have it figured out. Then upgrade to 3.5.

Another thing....are you also changing the host server?...because usually the database server should be set to "localhost."

[thenewuser]

Well great, it looks like I posted this in the wrong section...

Powered by: vBulletin Version 3.0.7

I just want to COPY my phpbb2 database from www.mysite1.com over to my new vB database at www.mysite2.com.

Maybe this is impossible, I wish I could just pay someone to do it for me.

[aelion]

You could always upload the phpbb database into a temporary one on the new site and import from that.....that would be the easiest way. If your database is quite large you could probably ftp it to the new server and get the host to install it into a temporary database. Again, I would do a trial run first. There are instructions on how to do it here.

[Steve Machol]

This line is almost certainly wrong (notice the period):

targetdatabase = vb.

As for the sourceserver, that server will need to be configured to allow remote MySQL connections from your server for this to work. Otherwise you will need to backup and restore the phpBB database on the vB server.

Note: The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore

[thenewuser]

Do you know of a service where I can pay someone to do it for me, I think this is over my head. :P

[Steve Machol]

We do not have an import service available at this time, but we are available for help and support if you need it.


http://members.vbulletin.com/members...ontactform.php