impex import errror

[dcallan]

Hi guys, I keep on getting a database error from my impex install. I tried to do this query manually and its returned no results but did run from the command line.

Anyone have any ideas?

<!--
Database error in vBulletin:ImpEx Target :
Invalid SQL: SELECT title, data FROM datastore WHERE title = 'ImpExSession'
mysql error: No database selected
mysql error number: 1046
Date: Saturday 08th of October 2005 09:37:43 PM
Script: http://localhost/vb/impex/index.php
Referer: http://localhost/vb/admincp/index.php?do=nav
IP Address: 127.0.0.1
-->

[Steve Machol]

This means the db info in your ImpExConfig.php file is wrong. You need to check and fix this info.

Also make sure sourceexists is set to 'true'.

[dcallan]

I'm 99.9% sure that these values are all correct.

"# If impex is installed in vBulletin you can ignore the target details
# as includes/config.php".

What exactly does this mean? Installed in vBulletin, does this mean if the impex folder is in the main vb folder. If so this is the case, and thus I ignored the target section as my main installations connects with the db fine.

Do you think it could be something to do with this? - I have vb installed on localhost but I want to access a db on the internet?

[Steve Machol]

This means that you do not have permissions to access this remote database. You will need to copy the db you are trying to import onto your vB server and then edit ImpExConfig.php accordingly.

[dcallan]

Hi steve, thanks for the reply,
I have a .sql file dump of my remote server on my desktop but do not know how to use this to put it into an actual database. do I just copy and paste all the sql statement to the CL and run them?

[Steve Machol]

Now you neeed to restore that backup to a new db. The only reliable method of restoring a database is with shell access via telnet or ssh. Please see the instructions here:

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

[drn]

I get this error when my main vBulletin dbtype is set to mysqli:

$config['Database']['dbtype'] = 'mysqli';

When I change this to mysql, ImpEx begins to work from within the admincp. I guess ImpEx doesn't support the mysqli - even if it is overridden in the ImExConfig.php.

Ben