interesting MySQL problem

[Anon]

Earlier today the power went out and, of course, the computer went down with it. Ever since MySQL will not "read" the my.ini file. I have basedir=D:/data/ specified yet it is pulling data from the default c:/mysql/data. I have deleted the my.ini file and uninstalled/reinstalled MySQL and it still uses all of the defaults. I cannot find any answer for this problem after searching all day so please do not reply with any RTFM comments... I already have. If there are any suggestions I would really appreciate it. Thanks in advance.

FYI:
This is a Windows 2000 Apache/PHP/MySQL setup that has worked flawlessly until the power outage.

[Anon]

My gut instinct says "windows registry". You can use "Start/Run/regedit.exe" (in the windows dir) to search the registry. Unfortunately, I just copied a working install of mysql form the d: drive on my laptop to this desktop, and started the server from D:\mysql\bin\winmysqladmin.exe, no install. My registry doesn't show any mysql.

That leads me to my other gut instinct, it could be a cache file in the "\TEMP" folder. Just delete everything in the \temp folder, and try again.

The only other thing I can think of is that when mysql is registered as a service, that registration holds the path to the my.ini file, and if it can't find the my.ini file where it expects it, then it'd use the defaults. You might even try puting the my.ini file you want, in the default my.ini location, or anywhere else you think mysql might look for my.ini.

I'm not much on NT, mostly win 9x and Linux(mostly Redhat).

Hope some of this help, if not now, then later.

William Janoch of ScriptingBiz.Com

[Anon]

Later yesterday, after I made my post, I tried just what you said. I deleted every mysql registry entry as well as clearing all the temp folders. Reinstalled and everything finally started working right. Had me worried for a while there since I wanted to keep the data on a seperate drive and mysql would only use the default. Much thanks!