Carrying on my own thread here....
I also find the following, if I execute 3.23.5a version with
mysqld --init-file=c:\\my3.23.cnf -P3307 it runs but doesn't
appear to read c:\my3.23.cnf
if I run
H:\webdbs\mydata>mysqld --init-file=c:\\my3.23.cnf --port=3307
--datadir=h:\\webdbs\\mydata3307 > err
mysqld: unrecognized option `--init-file=c:\\my3.23.cnf'
I get the error line and the server does not run, it outputs the output
of mysqld --help to the redirect file
Steve Ruby wrote:
>
> Steve Ruby wrote:
> >
> > The term "init-file" doesn't exist in the manual.html
> > file for 3.23.5a so I may be getting this wrong, but I don't think
> > that my win32 copy is respecting this directive.
> >
>
> Sorry I mean that it is NOT respecting the --init-file= directive
> see below.
>
> > My main server is running 3.22.26a for win32 c:\my.cnf
> > specifies databases are in h:\websbs\mydata\
> > works fine. I want to do some work with 3.23 so I installed
> > it an attempt to run another copy like this
> >
> > c:\mysql3.23\bin> mysqld --init-file=c:\my3.23.cnf -P3307
> >
> > the mysqld part of c:\my3.23.cnf looks like this:
> >
> > [mysqld]
> > tmpdir=c:\\temp
> > datadir=h:\\webdbs\\mydata3307
> > set-variable=key_buffer=85M
> > set-variable=record_buffer=1M
> > set-variable=table_cache=128
> > set-variable=sort_buffer=5M
> > set-variable=join_buffer=5M
> > set-variable=tmp_table_size=30M
> > set-variable=max_heap_table_size=14M
> > skip-name-resolve
> > port=3307
> >
> > h:\webdbs\mydata3307 contains only the mysql permissions database.
> >
> > If I then run
> >
> > c:\> mysql -P3307 -e "show databases"
> > I get a listing of all of my databases in h:\webdbs\mydata
> >
> > connecting to mysql monitor confirms that port 3307 is running the 3.23
> > copy.
> >
> > mysqld 3.23 on port 3307 is also writting to
> > h:\webdbs\mydata\hostname.err
> > instead of h:\webdbs\mydata3307\hostname.err confirming that it is using
> > the wrong datadir.
> >
> > Now since I don't see init-file in the manual.html all I am going on is
> > the line in mysqld --help to see what init-file should do, I am assuming
> > that it points it do a different location for a file like c:\my.cnf
> > which
> > is exacly what I need to run 3.23 on a different port.
> >
> > Also note, that the issue I sent a while back about trying to shutdown a
> > server
> > running on a different port with
> > mysqladmin -P3307 shutdown
> > seems to still be the case with 3.23 it doesn't do anything, the server
> > is still
> > up and running fine, even if there are no connected sessions when the
> > shutdown is executed.
> >
> > thanks much for all your help, I know 3.23. is in Alpha, just wanted to
> > bring
> > these issues to your attention.
> >
> > Steve
> >
> > ---------------------------------------------------------------------
> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> > posting. To request this thread, e-mail win32-thread868@stripped
> >
> > To unsubscribe, send a message to the address shown in the
> > List-Unsubscribe header of this message. If you cannot see it,
> > e-mail win32-unsubscribe@stripped instead.
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread870@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.
