sean c peters wrote:
I guess i dont fully understand how mysql uses my.cnf.
Global settings go in /etc/my.cnf.
Global to what? All mysql servers running on the machine, or some other
Yes, all servers and clients on the same machine.
definition? I guess my confusion is partially because my.cnf states the port number for both servers and clients, but both servers can't be listening on the same port.
Right. Option files are also explained in the manual <http://dev.mysql.com/doc/mysql/en/Option_files.html>.
/etc/my.cnf is read first, if it exists. DATADIR/my.cnf is read next, if it exists. For a client, ~/.my.cnf is read last, if it exists. Last setting wins.
Is it the case that i'll need to redefine some of the config options from /etc/my.cnf in DATADIR/my.cnf for each server. If so, that's fine, i just want to make sure i do this correctly, and don't cause an interruption of service in the production server.
Right. Settings which are server-specific should be moved from the global file in /etc to the server-specific file in DATADIR.
Most of what i've been reading about running multiple servers on the same box has seemed a bit confusing.
If you can turn that into specific questions, I'm sure someone on the list will have answers.
thanks much sean peters [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
