creating charector....

[greenguy14]

iv got my server up and running it called mikestestserver(bugged).
i get to the create charector screen and every time i make one it says name rejected please make another. i am using 5.3dr3.
i am getting "Error could not load item data but ignoreing" and alot of stuff above it about items in world.exe. that is only error i get on world.exe
do i have to have a database before i can play on my server? if so then how do i get one and how do i put it in my server.

[/code]

[samandhi]

Please see THIS (http://www.eqemulator.net/forums/viewtopic.php?p=68814#68814) thread to find out how to fix this error, which leads to your second question. Yes, you need to source in a database to use a server. See the tutorials and howtos forum under setting up your own server for help on this. You can find the latest db's to use with your version of EqEmu in the worldbuilding forum.

[greenguy14]

i am using the

http://prdownloads.sourceforge.net/sourceforge/projecteq/mw_052_053_alpha2.zip?use_mirror=unc

database but i cant find out how to source it. do i do it though cmd or mysql or what?
if cmd what do i type or in mysql what do i do.


i am really noob to this but i wont give up!!

[Scorpious2k]

database but i cant find out how to source it. do i do it though cmd or mysql or what?

extract the file from mw_052_053_alpha2.zip
start mysql

type use eq
type source <the name of the file you extracted above>
type exit

you're done

i am really noob to this but i wont give up!!

We were all noobs at one time. :-)

[greenguy14]

it said failed to open file?

i got to mysql in cmd then
did

use eq

source <MWnpcdb_050_default0_2.sql>
i got error 22 with braccets then with out i got error 2
both said same error message though
" Failed to open file '<MWnpcdb_050_default0_2.sql>' , error 22
"
Failed to open file 'MWnpcdb_050_default0_2.sql' , error 2

do i put the < and > in ?

[samandhi]

No <>'s.. Type this as follows:
mysql -u root myslq
USE eq;
source MWnpcdb_050_default0_2.sql;
quit

You have unzip the file and you also have to make sure that the sql file is in your c:\mysql\bin folder (granted c:\myslq is the location you installed MySQL to, which IS the location if you went default), and that should work just fine...

[greenguy14]

what locations does the file have to be in i have it in my build folder and mysql\bin is that it?

I got the same error said

Failed to open file 'MWnpcdb_050_default0_2.sql' , error 2

[wize_one]

when you extract mw_052_053_alpha2.zip the file would be mw_052_053_alpha2.sql probaly getting error due to file not named right

[greenguy14]

im still gettin the

Failed to open file mw_052_053_alpha2.sql , error 2

its the myqsl\bin folder is that the only place it has to be in?

thats where my winmysqladmin is and a like 20 or so .exe programs and a few other files.

[Monrezz]

Rename it db.sql and copy it into your mysql\bin folder.

Then point cmd promt to mysql\bin.

mysql -u root eq
source db.sql;


You're probably making a mistake in the file name somewhere, easier to simplify the filename and retry. ;)

[greenguy14]

yes i think i got it a bunch of

query ok 1 row affected (0.00)
query ok 1 row affected (0.00)
query ok 1 row affected (0.00)
query ok 1 row affected (0.00)
query ok 1 row affected (0.00)


this right?

getting thousends been like 4 min of this

[Monrezz]

Yes, you'll get something like 150,000 rows of that :P

Means everything's worked - go into Mysql front of EQAdmin if you have it, make sure you set up the options for your database so they're the same as found in your db.ini, and then you can see all the information in your database.

[greenguy14]

sweet finally i said i would never give up!!


so this take like 1/2 hour?

[Monrezz]

Depends what system your running, but shouldn't take too long.

Takes around 5 mins for me to fully source in MW, running a 2.2Ghz 512RAM.

If it keeps sourcing its working don't worry about how long it takes :)

[greenguy14]

it worked... sourced and everyting


but after i run world.exe it connects no errors
then i do boot5zones.bat and they open and close quickly it says version 5.1 so do i need to update this to 5.3 or sumthing.

[greenguy14]

i fixed it never updated the zone files in boot5zones stupid me was running zonedebug in it.