cant seem to get impex to work on importing

[BlueKnight]

I have impex loaded and showing up in the control panel goto the import screen for importing eve. Ask it to do the first thing to verify the database and it comes back with a flash of info of an error and then back to the main screen. I am bit confused of how I tell it I put my old database to import in the main forums directory. Where does it look for the source? how do i know what the source is called? do I put in the entire path on the impexconfig.php? I am confused.

[Jerry]

You need to restore the EVE database so ImpEx can read from it, then you put the database details in ImpExConfig.php as the source.

[BlueKnight]

is the exact path or where it is on local host and its name .sql? I unpacked all the packing eve did with the back up and uploaded to my server where v bulletin is

[Jerry]

That .sql file is a database back up, you'll need to restore that to a database so ImpEx can read from it.

http://www.vbulletin.com/docs/html/main/manual_database_restore

[BlueKnight]

ImpEx Database errormysql error: Invalid SQL: SHOW TABLES
mysql error: No Database Selected
mysql error number: 1046
Date: Tuesday 15th of August 2006 01:28:35 PM
Database: pnwfs4x4s_eve
MySQL error: No Database Selected


here is my error.. the database pnwfs4x4s_eve.sql is located in the public_html directory.... dO i have to give an exact path?

[Steve Machol]

No, as Jerry said you need to restore that backup to a fresh database.

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

Note: Some people have reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

[BlueKnight]

I did a complete back up of my entire batbabase and it compressed it into a tar.gz file. I unpacked it and you can clearly see all the data in logical places. I uploaded all these readable files to my server. is this what you meant?

[Steve Machol]

Is is a functioning database that you can view in phpMyAdmin? If not, then you haven't restored the db correctly.

[BlueKnight]

Steve I have uploaded it to my server. I will pm you my ftp info and you can go see if its right. Groupee is being wierd and not helpful at all.

[Steve Machol]

Please do not PM me for private suppoort. Use the support ticket system instead (link is in my sig.)