PDA

View Full Version : MySQL can't load my db


Mortamer
08-07-2004, 07:35 AM
is their anything I need to do to use the db at http://www.eqemulator.net/forums/viewtopic.php?t=15601& because it keeps saying it cant load the db, error: ""ERROR:
Failed to open file 'db.sql', error: 2" Hope that makes sense, didn't sleep much last night heh.

gottasummer
08-07-2004, 07:40 AM
did you copy db.sql into the c:/mysql/bin folder, or whatever your SQL is installed to? I am using a diff database, so I typed in source eqemudatabase.sql; or something like that.. also do NOT use a GUI or phpmyadmin, I tried them all they all will crash to my knowledge... but they are ok at editing the database, I am assuming, because I was able to view the database from phpmyadmin.

Mortamer
08-07-2004, 08:02 AM
yeah its in C:\mysql\bin. I am using the db EQEMu-SQL-06-26-04.sql from http://www.eqemulator.net/forums/viewtopic.php?t=15601& its just called db.sql.

gottasummer
08-07-2004, 08:05 AM
me too but you gotta extract it, and rename it to db.sql, so just right click it and click rename then type in db as the new name.

Anyway, that database is great but you have to rename it to db for it to work.

Mortamer
08-07-2004, 08:10 AM
hehe no thats not it, it was renamed, I figured it out =/. It needed the full file path (even though it was in the same folder as mysql.exe).

gottasummer
08-07-2004, 08:13 AM
oh. Good luck with your server, if all else fails you can co-admin my server, PSO-NET Legends.