Blah stupid newb question...

[Maceblade]

I cannot figure out what im doing wrong. Ive had a server before and I never could get mysql to source it I did it manually... Im sorry if this is redundant and I look like a moron but idk what im doing wrong.

I've followed the newest setup guide word for word. Only thing that varies is my version of mysql. I could not locate a v 5.10 the only one I could get was a 5.12. All Is well except when I go to source it.

http://img28.imageshack.us/img28/3813/errorxp.jpg

[sorvani]

change to the directory the SQL scripts are stored in before you start mysql

[c0ncrete]

you can also use this from a command line instead of sourcing from a mysql command prompt (for use in batch files)

mysql -u<username> -p --database=peq < PATH\TO\peqdb_revXXX.sql

[blackdragonsdg]

The problem is that you are not including a file path.

The following example will work if peqdb_rev2294.sql is located in base C:\
source c:/peqdb_rev2294.sql


Now load_player.sql and load_bots.sql will require file paths as well but you will also need to open those files up and complete the file paths for everything listed inside them.

[Maceblade]

http://img43.imageshack.us/img43/4540/error2wm.jpg
I've even downloaded a new Rev and uninstalled mysql and still nothing... its gotta be something small and dumb im missing.

[Derision]

You need to unzip the peqdb_rev2294.sql.gz file (note that it has a file type of GZ file, not SQL file).

As the icon is not a zip file icon, make sure you have winzip or winrar installed to be able to unzip it (can't remember if winzip handles .gz, but I think winrar does).

[sorvani]

Also, do NOT source in the database like you are doing with the path. That is simply going to cause you more problems since you do not know what you are doing in the first place. If you were a more advanced computer user there are ways to do it but you are obviously not.

Do as I instructed and change to the peqdb folder BEFORE you start mysql.
Download DB from SVN.
Unzip it.
open a command prompt.
type: cd \peqdb
type: mysql -uroot -p peqdb
enter your DB password when prompted
source the sql file
source load_player sql file.

[Maceblade]

Yes that was my issue... for some reason winrar was not acting as my default extractor and I failed to notice the gz extension. Thanks alot! :)

[Maceblade]

Everything is sourced and ready my only error now is that its looking for perl510.dll in which im assuming is perl 5.10 and the only ones i could find are 5.16, 5.14 and 5.12... anyway around this?

[c0ncrete]

i've never tried using strawberry perl instead of active state's, but they have 5.10 up for download still.

[Maceblade]

Thanks C0ncrete that actually helped. I copied the perl510.dll out of it and placed it in my bin folder and it worked. Thank you everyone for your help.