Problem...

[Justin P]

it tells me in the database check to Please set 'sourceexists = true' in ImpExConfig.php and i do then it saids Connection to source server failed. Check username and password. on the Impex index.php page?? whats up with this

[Jerry]

failed for the source or the target ? have you filled in both in ImpExConfig.php ?

[Justin P]

heres what i got.....

-----
targetdatabasetype = mysql
targetserver = localhost
targetuser = tww_Justin
targetpassword = 575695
targetdatabase = tww_twwforums
targettableprefix =


sourceexists = true

sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = woforums_ips
sourcepassword = xc3ky2c
sourcedatabase = woforums_ipb
sourcetableprefix =

--------
thats all

[Justin P]

and i can put sourceexists to false and it works but it tells me in the database check to turn it back to ture and then i get this error on the Associate Users page

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



There seems to have been a slight problem with the TheWrestlingWorld database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT id, name
FROM members
ORDER BY id
LIMIT 0,25
mysql error:

mysql error number: 0

Date: Wednesday 03rd of November 2004 07:40:21 PM
Script: http://www.thewrestlingworld.com/impex/index.php
Referer: http://www.thewrestlingworld.com/impex/index.php
Username: Justin
--------

[Steve Machol]

The 'sourceexists' field has to be 'true'. The connection error means that the source db info you provided is not correct.

[Justin P]

Well its saying "Connection to source server failed. Check username and password."


thats sounds like a server issue. i put localhost for the sourceserver cause thats what it saids it is...

[Steve Machol]

Are both databases on the same server?

[Justin P]

not the same server????? my site is located at http://www.thewrestlingworld.com/ and im getting the data from http://woforums.ipbhost.com/

heres the data from both sites....
=============
targetdatabasetype = mysql
targetserver = localhost
targetuser = tww_Justin
targetpassword = 575695
targetdatabase = tww_twwforums
targettableprefix =

sourceexists = true

sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = woforums_ips
sourcepassword = xc3ky2c
sourcedatabase = woforums_ipb
sourcetableprefix =


=============

[Steve Machol]

Then you can't use 'localhost' for the sourceserver name since it's on a different server. You will need to use that MySQL server name, and that server will need to be configured to accept MySQL connections from your local server.

Otherwise you will need to move the IPB database to the server containing the vB database.

[Justin P]

how do i configured the mysql to take connections from my server and how do i find out the name of the server? I can give u the url and login name and password to the cpannel so u can look if u want

[Steve Machol]

I don't know. However you will need to have root access to that server in order to do this. If you don't have root access, then you'll need to ask the web host.

[Justin P]

Is it always this hard to just import databases... I put a info.php file onto the server and heres all information about the whole server.....
---------------------
http://woforums.ipbhost.com/info.php

[Steve Machol]

Most imports are done with both databases on the same server. As I mentioned, if they are not on the samer server you need to configure that server to accept connections from your server. Unless you have root access to this server you will not be able to do this.

I believe you are going to need to backup that database and restore it to your server in order to do this import. The only reliable method of backing up and resto
ring a database is with shell access via telnet or ssh. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore