[EMAIL PROTECTED] wrote: > > I read somewhere that mysql reads /etc/my.cnf before it does any > command line options, is this correct? If so, how can I have a my.cnf > file > and then run two servers if I have to have a [mysqld] section in the > my.cnf > file that tells the server which port and socket to listen on? > > Should I remove the [mysqld] section from the file and start the servers > from the command line using command line options and just leave the > innodb/mysql-client options in my.cnf ? > > Any help ?
If you want your my.cnf file to apply only to one server, put it in that server's data area (e.g. /usr/local/mysql/var/my.cnf). So basically you'd have an /etc/my.cnf for global options and then a couple of my.cnfs for the two seperate servers in the appropriate data areas. -- John Klein, Database Applications Developer | Omnia Mutantur, Systems Group - Harvard Law School | Nihil Interit --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
