Cant get the DB to source

[Gavin2010]

i downloaded all the needed programs , but when i go to source the DB zip file nothing happens it gives me an error 2 and says couldnt open

[chrsschb]

Did you unzip it? It's a .gz file to start with. Try using 7zip.

[Gavin2010]

yes i did not using that program but i did unzip the folder . where do i unzip it again just for clarity

[chrsschb]

Doesn't matter really, just make sure you put the full path when you type in source, ie:

source C:/PEQ/peqdb_rev1667.sql

[Gavin2010]

his is what i get





Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.0.85-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> source peqdb_rev1589.sql;
ERROR:
Failed to open file 'peqdb_rev1589.sql', error: 2
mysql> source C:/PEQ/peqdb_rev1667.sql
ERROR:
Failed to open file 'C:\PEQ\peqdb_rev1667.sql', error: 2
mysql> source C:/PEQ/peqdb_rev1667.sql
ERROR:
Failed to open file 'C:\PEQ\peqdb_rev1667.sql', error: 2
mysql> source C:/PEQ/peqdb_rev1589.sql;
ERROR:
Failed to open file 'C:\PEQ\peqdb_rev1589.sql', error: 2
mysql> source C:/PEQ/peqdb_rev1589.sql'
ERROR:
Failed to open file 'C:\PEQ\peqdb_rev1589.sql'', error: 2
mysql>

[Gavin2010]

and BTW i keep crashing after being in game after about 5 mins of playing the client crashed error pops up everytime , any ideas on a fix , i reinstalled and still have the error

[Tabasco]

I'm pretty sure input redirects work in CMD so if the command line mysql client is in the path, you could try: mysql -p [database name] < peqdb_rev1589.sql.

You could also try a GUI tool like navicat or the official mysql management workbench. I haven't used either one, but the old query browser used to let you load from file.
http://www.mysql.com/downloads/workbench/

[Chanus]

I'm having a similar problem. The database loaded just fine, but when I try

mysql> source load_player.sql;

I get:

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

and if I try"

mysql> source e:/peqdatabase/load_player.sql;

I get:

ERROR:
Failed to open file 'player_tables\aa_timers.sql', error: 2
(... same error for every file in the player_tables directory)

All the files it gives an error for are in the directory, so I'm not really sure what would be going wrong.

[lerxst2112]

Open command
cd to e:\peqdatabase
Then run mysql and source the file. Everything is relative directories, so you can't do it from any other path.

[Chanus]

Ah, okay. Thanks!