I'm trying to setup binary logging to eventually get replication
between two servers. However, any updates that I do to the
database are never written to the binary log.
I'd appreciate any pointers to what I may have misconfigured. Here
are some details about what I've tried so far:
Version: 3.23.54-log (Linux x86)
[EMAIL PROTECTED] binary-logs]# ps axww|grep mysqld
4739 ? S 0:00 /bin/sh /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf
4766 ? S 0:00 /usr/libexec/mysqld --defaults-file=/etc/my.cnf
--basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
[EMAIL PROTECTED] binary-logs]# more /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
server-id=1001
log-bin=/var/lib/mysql/binary-logs/veritech
binlog-do-db=veritech
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[EMAIL PROTECTED] binary-logs]# pwd
/var/lib/mysql/binary-logs
##### Binary logfiles get created
[EMAIL PROTECTED] binary-logs]# ls -lh
total 16k
-rw-rw---- 1 mysql mysql 73 Feb 26 14:11 veritech.001
-rw-rw---- 1 mysql mysql 40 Feb 26 14:11 veritech.index
mysql> show variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin | ON |
+---------------+-------+
1 row in set (0.00 sec)
mysql> update Appraisr set AppraiserName='Ken' where AppraiserCode=26;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
##### No change in the files.
[EMAIL PROTECTED] binary-logs]# ls -lh
total 16k
-rw-rw---- 1 mysql mysql 73 Feb 26 14:11 veritech.001
-rw-rw---- 1 mysql mysql 40 Feb 26 14:11 veritech.index
#####
Thanks for any suggestions.
--
Ken Schweigert, Network Administrator
Byte Productions, LLC
http://www.byte-productions.com
---------------------------------------------------------------------
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
