load_player.sql.. I just can't figure it out...

[Dayhawk]

I have been trying for over an hour and ahalf trying to figure out the issue here. I got the DB to source without an issue but when it comes to load_player.sql it wont happen. Here is a clipit of what is happening...

--------------

ERROR:
Unknown command '\l'.
-> source c:\peqdb\peqdatabase\load_player.sql;
--------------
C:eqdbeqdatabase\load_player.sql
source c:
--------------

--------------
C:eqdbeqdatabase\load_player.sql
source c:eqdb
--------------

ERROR:
Unknown command '\l'.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'C:eqd
beqdatabase\load_player.sql
source c:eqdbeqdatabase\load_player.sql' at line 1
mysql>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Please if you could post a detailed description on the fix. Thank you.

Dayhawk~

[Brewhaus]

I don't remember the exact syntax, but try putting the path in quotes, try using forward slashes, try using relative paths, etc..

[Dayhawk]

When trying to do it with forward slashes it started working but all files FAILED with "error 2". Been trying for 2 hours now everything.

[Akkadius]

Originally Posted by Dayhawk

I have been trying for over an hour and ahalf trying to figure out the issue here. I got the DB to source without an issue but when it comes to load_player.sql it wont happen. Here is a clipit of what is happening...

--------------

ERROR:
Unknown command '\l'.
-> source c:\peqdb\peqdatabase\load_player.sql;
--------------
C:eqdbeqdatabase\load_player.sql
source c:
--------------

--------------
C:eqdbeqdatabase\load_player.sql
source c:eqdb
--------------

ERROR:
Unknown command '\l'.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'C:eqd
beqdatabase\load_player.sql
source c:eqdbeqdatabase\load_player.sql' at line 1
mysql>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Please if you could post a detailed description on the fix. Thank you.

Dayhawk~

You have to put the load player folder in the same directory in which you execute the .sql

Make sure you have a database created and have the database selected.

run the command as source directorypath\load_player.sql; <---- semi-colon

[Dayhawk]

I put the player tables folder in the same directory as the DB in MYSQL folder. I tried what you told me to od and it still has not worked.

[Akkadius]

Originally Posted by Dayhawk

I put the player tables folder in the same directory as the DB in MYSQL folder. I tried what you told me to od and it still has not worked.

Make sure it is in the bin folder, then you won't have to specify any directory just:

source load_player.sql;

[Dayhawk]

Put the player_tables folder and the load_players.sql in the bin folder?

[Dayhawk]

Tried what you said, put it in ben folder still not working, getting Error 2

[Akkadius]

Originally Posted by Dayhawk

Tried what you said, put it in ben folder still not working, getting Error 2

Have you created and selected a database prior to this operation? What is your error message now.

[Dayhawk]

Akk,

After moving the Player_Tables folder to "bin" in the Mysql folder along with load_player.sql then rebooting CMD, I slected the database that i created "peq" and typed:

source load_player.sql

Still recieving error 2.

[Dayhawk]

Failed to open file 'load_player.sql', error: 2

[Akkadius]

Originally Posted by Dayhawk

Akk,

After moving the Player_Tables folder to "bin" in the Mysql folder along with load_player.sql then rebooting CMD, I slected the database that i created "peq" and typed:

source load_player.sql

Still recieving error 2.

Need a semi colon after your command, for some reason it's picky about it.

source load_player.sql;

[Dayhawk]

Used a semi colon, failed.

[joligario]

You need to remember that it is loading other sql files. Some systems won't follow the path once it starts loading or it will follow the path relative to where your loading the SQL from. The way I like to do it is to leave the files and folders in tact the way you get them from the svn (well I extract the database zip file of course) and then I start mysql from within the directory where the load_player and database revision files are located. If it were a single sql file, it would work using source "folder\file.sql"; method, but when the .sql file contains a chain, a lot of systems don't like to follow the path relative to your sql.

[Dayhawk]

Got everything working now when I launch my server it is showing error

eqlaunch.exe - unable to locate DLL

The dynamic link library MSVCP90.dll could not be found in the specified path
D:\eqemu;.;C:\winnt\system32;C:\winnt\system;C... so on and so forth...