The following setup is on MySQL 4.0.16 on Debian LINUX.
It appears as if my replication master is not logging changes to any databases. My my.cnf is as follows:
[code] server-id = 154 log-bin = /var/log/mysql/mysql-bin.log binlog-do-db = dollars [/code]
The server status is great.
[code] File Position Binlog_do_db Binlog_ignore_db mysql-bin.005 4 dollars,epoch [/code]
The slave connects correctly, and waits patiently for updates. The master logs the slave connecting, but gives it nothing.
I'm certainly using the correct database, and my transactions are being commited. I've tried MyISAM and InnoDB tables, and neither are shown.
Here is a sample query:
[code] use dollars ; create table Bobby ( id int unsigned primary key auto_increment, ssn int ) type=InnoDB ; insert into Bobby (ssn) values (12312),(12312544),(1231231); commit ; [/code]
Now, the binlogs before the query are as follows:
[code] [EMAIL PROTECTED]:/var/log/mysql$ dir total 28 drwxrwxrwx 2 dollars mysql 4096 Dec 1 21:53 ./ drwxr-xr-x 9 root root 4096 Dec 1 06:52 ../ -rw-rw---- 1 dollars users 1271 Dec 1 21:36 mysql-bin.001 -rw-rw---- 1 dollars users 655 Dec 1 21:59 mysql-bin.002 -rw-rw---- 1 dollars users 58 Dec 1 21:49 mysql-bin.index -rw-rw---- 1 dollars users 348 Dec 1 21:49 mysql-slow.log [/code]
After the preceding code block, the binlogs have increased.
[code] [EMAIL PROTECTED]:/var/log/mysql$ dir total 24 drwxrwxrwx 2 dollars mysql 4096 Dec 1 21:59 ./ drwxr-xr-x 9 root root 4096 Dec 1 06:52 ../ -rw-rw---- 1 dollars users 1271 Dec 1 21:36 mysql-bin.001 -rw-rw---- 1 dollars users 904 Dec 1 22:02 mysql-bin.002 -rw-rw---- 1 dollars users 58 Dec 1 21:49 mysql-bin.index -rw-rw---- 1 dollars users 348 Dec 1 21:49 mysql-slow.log [/code]
As you can see, the bin.002 log increased from 655 bytes to 904 bytes. However, running mysqlbinlog on the 002 file STILL produces nothing:
[code]
[EMAIL PROTECTED]:/var/log/mysql$ mysqlbinlog mysql-bin.002
# at 4
#031201 21:49:39 server id 154 Start: binlog v 4, server v created 691231 19:00:00
[/code]
There are two things I notice about this output. First, the last part "created 691231 19:00:00" is 7pm on New Years Eve 1969. Is this coincidentally near the epoch, or was this a missed compiled time? I don't think this should be the time of the binlog creation....
The second thing I notice..... well.... the second thing I notice is the damn thing isn't working. So someone help me.... please?
Lukas
_________________________________________________________________
online games and music with a high-speed Internet connection! Prices start at less than $1 a day average. https://broadband.msn.com (Prices may vary by service area.)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]