MySQL looks for data in the wrong directory!

[Guest_imported]

I run MySQL with mysqladmin tool under windows 98.
Sometimes when i do "refresh databases" it looks for data in a different directory, usualy C:\windows\system
and of course i doesn't find it, so any command i send to mysql returns a "table not found" error.
But it returns to normal , for a while, when i restart it.
What could that be? How do i fix it?

 

[ToeShot]

You should Have an my.ini file that looks something like this

[WinMySQLAdmin]
Server=C:/MYSQL/bin/mysqld-opt.exe
user=root
password= <-- Took Out My Password
QueryInterval=10

[mysqld]
basedir=C:/MYSQL
#bind-address=127.0.0.1
datadir=C:/MYSQL/data
#language=C:/MYSQL/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M

notice the lines in red make sure yours are the same. MySql should be installed in it's own directory on the C: drive.
This will take care of your refresh problems

HTH

 

[Guest_imported]

Thanks, but it still didn't help.
It runs fine for a while, but then all of a sudden i get an error saying that a certain database doesn't exist. Whne I upen up MySQLAdmin and refresh the databases, i get a directory listing for C:\windows\system
And i have already configured the my.ini file and in the variables listing datadir is C:\mysql\data
so I'm stumped.