From: Steve Ruby
Date: October 29 1999 3:50pm
Subject: Re: win32 and --init-file directive
List-Archive: http://lists.mysql.com/win32/870
Message-Id: <3819C233.7DD275DA@seawingsub.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



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.