Eve import ???

[rnn-2]

I am doing this on a windows server. I have direct access to the server.

I did a backup off of infopop which I assume is a mysql dump.

I unzipped this file and placed it into a subfolder of Impex and it has a file called eve.sql and seven other files with only 1 kb each.

I edited the ImpExConfig.php file as follows:
Source exists = TRUE
Source db type = mysql
Source Server = local host
Source User and Password =
Source database = eve
Source table prefix =

I get the following error

Database error in vBulletin:ImpEx Source 3.0.1:
cannot use database eve
mysql error: Unknown database 'eve'
mysql error number: 1049

Apparently it cannot parse the database or locate the database not sure?


Bob

[Steve Machol]

I'm pretty sure you need to restore the Eve db backup to a new database. It won't work from an sql backup file.

[Zachery]

Also localhost is one word not two. :)

[rnn-2]

So I should setup a new DB in Mysql for the Eve db.

I'm green with Mysql, how do I do that?

[Zachery]

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

:) that should be of some hel0p

[Jerry]

Yes, the eve importer works from a database not the back up file.

(Though that does give me an idea ........;) )

[rnn-2]

The dump from infopop has several files, do I only need the one that says ***.sql there are seven other files with only 1 kb each.


Also will the importer make all the forums or do I need to add each one before hand.

What other steps are there?


Thanks
Bob

[Jerry]

Load the main SQL file to a database.

Download the importer (impex) and read the impex.readme.txt file in the download for more details of how to do it.

ImpEx will create all the forums.

[rnn-2]

You making certain assumptions, those notes are for people that know MYsql.

They are not straight forward.

I can setup a windows server with SQL (microsoft) in less time than this has taken.

I still can't get the db into mysql tried several times/ways.

I need a little more step by step.


I'm glad the importer will make the forums that will save time.

I just hope I can get it loaded in the right place, why can't the importer just have a way to point to a location.


Thanks

Bob

[Steve Machol]

See this documentation for restoring a db backup:

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

[rnn-2]

Still can't get it to work, I entered the command to make and upload the new DB

I get a prompt.

I opened up the Mysql folder nothings there?

I made a folder and copied the eve.sql db into it tried to run import/export the screen is blank.

I'm starting to regret this purchase, HELP.


Bob

[Zachery]

if you enter that command into the promt, it should hold for a second then return the promot $bash or $jailscript to you (assuming your on linux). then the import was successfull.

[rnn-2]

Zac,

please read the thread from the beginning "It is windows system"


I am in a command promt.

I am on the server directly no telnet.

Nothing happens.

I typed in the following:

mysql -u myusername -p mydatabasename < /folder/folder/imex/chat/eve.sql

Thanks
Bob

[Steve Machol]

Nothing happens? Honestly I don't see how that could be. 'Tis a mystery.

[Zachery]

you need to be in the mysql directory for that to work then :) or have it part of your path :)

[rnn-2]

In the mysql monitor in CMD PMT i put

Mysql> -u myusername -p mydatabasename < /folder/folder/imex/chat/eve.sql


Bob