You need to have log-slave-updates in my.cnf
On Thu, Jun 21, 2001 at 11:14:54AM -0400, Brian Reichert wrote:
> 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
--
My pid is Inigo Montoya. You killed -9 my parent process. Prepare to vi.
---------------------------------------------------------------------
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
