Re: my.cnf being renamed

[jim barchuk]

HiHi1

> I'm running mysql on NT and have a my.cnf file in c:\ directory.
> I noticed that it is being renamed to my_cnf.bak. Does anyone know
> why it happens? I know i don't do it and don't have any scheduled
> scripts to do it.

I found a possible answer for this at groups.google.com related to
winmysqladmin:

http://groups.google.com/groups?q=my_cnf.bak&hl=en&lr=lang_en&rnum=4&selm=994hoi%2469l%241%40FreeBSD.csie.NCTU.edu.tw

But I'll quote it here just in case that URL doesn't work or wraps too
mangly.

If that's not the exact fix it does lead to the clue of looking around
your HD for other my.* type files.

Have a :) day!

jb


From: "Luc Van der Veken" (lucvdv@stripped)
 Subject: RE: data folder
 Newsgroups: mailing.database.mysql-win32
 Date: 2001-03-19 01:00:08 PST

> -----Original Message-----
> From: Remy [mailto:remy@stripped]
>
> Hi
> Have a problem.
> Installed MySQL server 3.23.33-debug on a win 98
> and it works great. Only thing, that it looses it's data
> folder location.
> When I start the server, it finds my database, but i I try
> again in 5 minute
> it is lookind for my database for a complete different folder....?
> What is the problem.

This can be caused by placing your options in c:\my.cnf and then later
running winmysqladmin: it renames my.cnf to my_cnf.bak and starts using a
\windows\my.ini file instead, without taking over the options that were
already specified in my.cnf.

Put the options in my.ini instead if you intend to use winmysqladmin
(using
the same syntax as in my.cnf).

There is something weird about this though: your config options list the
default paths, so it shouldn't even be necessary to specify them.

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

ob-filter-word: table

-- 
jim barchuk
jb@stripped