Sourcing for server

[nezmyth]

so im trying to source load_player.sql and its been giving me problems, mysql is located in the same directory as load_player , and i cant figure out what im doin wrong could use a little bit of assistance thank you .

http://i27.photobucket.com/albums/c191/ardianko/eee.jpg

[jkennedy]

it looks like your not in your EQ Database go back to the server guide and read the sourcing part again

[nezmyth]

actually i am , i login with my password and everythings fine (MYSQL DB atleast)... hmmm i mean it sources revdb_xxxx.sql fine , but when i get to load_player.sql it errors (2)

[jkennedy]

and ur load_player.sql and your revdb_xxxx.sql are both in same location?

[pfyon]

You can't cd at the mysql command prompt. You need to either use

source "c:\program files\......etc;"

or put the sql in the same folder as mysql.exe and just "source load_player.sql;"

[nezmyth]

@JKKENNEDY - yep they are both in the same loc

i just put my load_player.sql in the mysql.exe folder, right under the .exe file actually and i went to the prompt, did - use [db] ... sourced load_player.sql; and it just gave me like 20 error queries

' FAILED to open file 'player tables\raid details.sql1.' error: 2 ' << similar to that

also tried method one before, gives me the same thing. hmm


http://i27.photobucket.com/albums/c191/ardianko/2.jpg

[pfyon]

load_player.sql sources a bunch of sql files under a player_tables\ folder, so you need to put that in the mysql.exe folder as well.

[nezmyth]

thank you very much =] that worked for me , appreciate it a bunch.