HI, everyone, I met a problem about setting up replication(master/slave) of mysql sever on unix boxes. Mysql servers are installed under "/usr/local/" on master and slave and they can be run under "/usr/local/mysql/bin". It seems to me that I have three choices where to put my configuration files, my.cnf, after I modify them for master and slave respectively . 1) /etc/my.cnf (global options) 2) DATADIR/my.cnf (Sever-specific option) 2) ~/.my.cnf (User-specific option) I have already tried all the three options, but only the first one worked. For sever-specific option, DATADIR that I choose to use is "/data/mysql" on my unix. And for User-specific option, I have tried my home directory "/home/joseph". For either of these two cases, it is obvious that mysql server didnot read the modified configuration under these two directories, because I tried "show master status" and "show slave status" and find nothing happened. Anyone can answer why and how to work it out under last two cases? thank you, Joseph
