I've got the #2 error while doing the guide

[joligario]

It goes into whatever folder you want. The files just include code that helps to create the database. You can load them from any directory. Just as long as you change into that directory before executing the mysql -u root -p command.

[Calypso73]

I don't know. I pretty much went right by what the info told on the server creation page. It just doesn't seem to be locating the load_player.sql file, although it's right there. Isn't there any way of extracting that without using the mysql command line? Otherwise I'm just going to try at a later time. Thx for the help though.

[joligario]

You can do it manually or copy/paste.

Copy the block of code, right click the cmd window and select paste or you can manually type each line in... More prone to typos though.

[Calypso73]

Well I give up. I've tried numerous times to set this up and always get stuck at the source load_player.sql . it just gives me "Failed to open file 'load_player.sql', error: 2"

I've also tried copying/pasting files to the command prompt window and get the same error. I remember setting up a server awhile back(2 yrs ago) and didn't have this trouble. Oh well, thx for the help though. I'll keep searching for some answers on the forum or other site

[joligario]

Ensure all the tables are in the same folder as your load_player.sql and make sure your load_player.sql looks like this:

source aa_timers.sql;
source Banned_IPs.sql;
source account.sql;
source botinventory.sql;
source botleader.sql;
source botsowners.sql;
source character_.sql;
source character_backup.sql;
source commands.sql;
source eventlog.sql;
source faction_values.sql;
source group_id.sql;
source group_leaders.sql;
source guild_members.sql;
source guild_ranks.sql;
source guild_relations.sql;
source guilds.sql;
source hackers.sql;
source inventory.sql;
source launcher.sql;
source launcher_zones.sql;
source name_filter.sql;
source object_contents.sql;
source petitions.sql;
source player_corpses.sql;
source player_corpses_backup.sql;
source quest_globals.sql;
source rule_sets.sql;
source rule_values.sql;
source sharedbank.sql;
source timers.sql;
source variables.sql;
source zone_flags.sql;

[Calypso73]

Yes it looks exactly like that, but when I paste it to the command prompt window, it just gives all files the failed to load error:2

[Xenezie]

It looks to me that you've forgot to end your command with a ;

Try

source load_player.sql;

or

\. c:/YOURDIRECTORY/load_player.sql;