Error 1049

[dmitri70]

Hi!

I have downloaded and installed the latest version of MySQL for Windows (3.23) from

http://www.mysql.com.

I am running W98. mysqld starts without a problem, mysqlshow displays mysql and test databases as expected. However, in several minutes the same mysqlshow may display just about anything. It really looks as if it wanders off to some random directory and shows the list of subdirectories... Over the time, as one could guess, the list of 'databases' changes.
I installed it in c:\mysql and [mysqld] section of my.ini does have correct basedir and datadir. mysqladmin variables shows correct datadir too.

Has someone seen anything like this?

Thanks.

 

[piti]

the 1049 error is a "ER_BAD_DB_ERROR The database didn't exist" error
maybe a hdd prob? or misconfigured my.cnf?

 

[dmitri70]

I guess, I forgot to make my point. I get error 1049 in mysql when I try to do 'use mysql' for example. This is happening because of the reasons above. The disk seems to be fine.
my.ini literally has the following:

[mysqld]
basedir=c:/mysql
datadir=c:/mysql/data

These are the directories where everything is installed. In fact, mysqld finds no problem with the setup. And, as I said, I can see the databases correctly, but only for some time...
I actually tried to install it on another PC, and the result was the same(!). The only thing that is common between these PCs is that they are hooked up to the same phone-line network. I had some suspicion about TCP/IP settings, but how can they affect sporradic directory change?

 

[piti]

when this happens what is the value of the datadir variable?

 

[dmitri70]

datadir always points to the correct location, i.e. c:/mysql/data

 

[piti]

well :-|
try to download mysql again and install it - maybe you have a buggy one

 

[dmitri70]

I don't think so. I tried it on another machine, as I said before, and the result was the same. However, the subrelease was different. I am thinking, maybe it's some kind of a virus, but then why does not it have a similar effect on the other applications?