I hope I've merely misread instructions.
I've successfully set up replication, a master to one slave.
However, even though the slave was comfigured to maintain both a
'classic' update log, as well as a binary log, none of the stuff
it's replicating are reflected in the logs. Said logs are created:
slave1# ls -ld *
-rw-r--r-- 1 mysqld mysqld 73 Jun 18 18:53 slave1-bin.001
-rw-r--r-- 1 mysqld mysqld 31 Jun 18 18:53 slave1-bin.index
-rw-r--r-- 1 mysqld mysqld 69 Jun 18 18:53 slave1.001
But, this is after I imported an entire database via replication.
Does anyone have any advice?
My environment:
slave1# uname -r -s
FreeBSD 4.2-RELEASE
slave1# /usr/local/libexec/mysqld -v
/usr/local/libexec/mysqld Ver 3.23.36 for unknown-freebsdelf4.2 on i386
slave1# ps auxwwe -p `cat /var/mysqld/db/mysqld.pid`
USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND
mysqld 55910 0.0 2.5 26976 25644 p0 S Mon06PM 26:31.02
MYSQL_TCP_PORT=3306 OLDPWD=/var/mysqld 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=bmdb1.ops.about.com --master-user=repl
--master-password=********* --server-id=2
--log-bin=/var/mysqld/log/slave1-bin
--log-update=/var/mysqld/log/slave1
--
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