MYSQL problem

[zole123]

I have followed the emulator pdf to the letter. But the part that says:

cd peqdb

and type

mysql -u root -p

I receive the error "mysql" is not reconized as an internal or external command.....or batch program

_______________________

also when i run mysql command line server and type in:

create database peq;
\u peq
source load_player.sql

I receive "faailed to open file 'load_player.sql' error:2

_______________________

If i change it and this:

create database peq;
\u peq
source c:\peqdb\load_player.sql

I receive "failed to open file '*****.sql', error: 2

===========================

Please help :)

[Andrew80k]

Do you have the database downloaded and extracted to that location? As for your first problem, you seem to have solved it by being able to login to the database. Yes?

[zole123]

yes the database is in the correct place. I am using win vista. It appears that I cant run the mysql from the directory of the database...

[xxarthurxx]

it should load either way... are you sure you installed the most uptodate vista compatable build? it should work with no problems otherwise... also for each time you atempt to build a new DB you must delete the old one completly... id re install remove the BD and then try again

[zole123]

Ok but I am not familiar with sql at all are you saying i should delete the db 'peq"? If so whats the command??

[zole123]

Sorry done that and still didnt fix my problem. Any more suggestions?? I will try them all :)

[xxarthurxx]

do you use windows? if so just use windows explorer and go into that folder and delete the db is there is one... also check in the mysql folder for any folders with your db as their name, delete those as well... then uninstall mysql and delete its folder. re install and follow the steps in the server setup guide exactly.

[GeorgeS]

Run cavedudes installer and if a problem still persists it's the mysql install. Very hard to troubleshoot that, but I often uninstall then reinstall.
I also tested mysql 5.x and cavedudes installer under vista and it worked fine.
It's possible you may need to turn of UAC and run as admin in Vista.


GeorgeS