On Thu, Jul 12, 2001 at 03:49:12PM -0700, Jeff Philapy wrote:
> It is hard to say where I am confused because the
> HOWTO requires me to try and follow it as I setup
> replication. So let me try and follow the
> documentation and if I see anything that can make it
> more clear then I will let you know. One thing that
> does come to mind though is maybe adding something
> that helps users to understand the process a little
> more clearly in advance without having to try and
> follow the documentation first. I don't know what you
> would put for that.
>
> I do have one question though, where is the my.cnf
> located? I ran locate my.cnf and it returned no
> results.
There may not be one at all. All of the directives in my.conf can
be supplied on the command line to mysqld. I prefer to avoind
my.cnf for a variety of reasons, not the last of which is that I
can, from 'ps', see pretty much everything I need to know about
the daemon.
Note the last three of these lines. I've censored some sensitive
information, but the rest show you what you might need WRT supplying
stuff on the command line. (I may not have all of this correct,
BTW. I'm still exploring replication myself.)
slave1# ps auxwwe -p `cat /var/mysqld/db/mysqld.pid`
USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
mysqld 61562 0.0 0.2 11220 1768 p0- S 22Jun01 4:22.20
MYSQL_TCP_PORT=3306 log_dir=/var/mysqld/log
TMPDIR=/var/tmp PATH=/usr/local/bin:/usr/bin:/bin:/usr/sbin
MYSQLD_DB=/var/mysqld/db UMASK=0644 DBI_HOST=localhost
MYSQL_BASE_DIR=/usr/local PWD=/var/mysqld/supervise UMASK_DIR=0777
/usr/local/libexec/mysqld --language=/usr/local/share/mysql/english
--port=3306 --pid-file=/var/mysqld/db/mysqld.pid --datadir=/var/mysqld/db
--basedir=/var/mysqld/db/mysql --tmpdir=/var/tmp --exit-info
--set-variable=max_connections=1000 --master-host=*************
--master-user=repl --master-password=****** --server-id=2
--log-slave-updates --log-bin=/var/mysqld/log/slave1-bin
--log-update=/var/mysqld/log/slave1
But, as to your original question: see
<http://www.mysql.com/doc/O/p/Option_files.html>
For a description of possible locations for my.cnf.
> Thanks,
> Jeff
--
Brian 'you Bastard' Reichert <[EMAIL PROTECTED]>
37 Crystal Ave. #303 Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path
---------------------------------------------------------------------
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