Dyego Souza do Carmo wrote:
I'm using MySQL/InnoDB 4.0.12
I set replication to replicate only database escribaupdate...
The bug is:
I connect in database escribaupdate and run: delete from escriba_autorizacao;
go to shell and execute:
scribthree:/database/log-bin# /usr/local/mysql4/bin/mysqlbinlog logbin.001 # at 4 #030331 13:26:05 server id 1 log_pos 4 Start: binlog v 3, server v 4.0.12-log created 030331 13:26:05 # at 79 #030331 13:31:33 server id 1 log_pos 79 Query thread_id=19 exec_time=0 error_code=0 use escribaupdate; SET TIMESTAMP=1049128293; delete from atualiza_autorizacao;
ok , the BINLOG only replicate the database command... but...
before it , i insert rows in atualiza_autorizacao... and : I connect in database *mysql* and run: delete from escribaupdate.atualiza_autorizacao;
For my suprise i go to shell and execute: scribthree:/database/log-bin# /usr/local/mysql4/bin/mysqlbinlog logbin.001 # at 4 #030331 13:26:05 server id 1 log_pos 4 Start: binlog v 3, server v 4.0.12-log created 030331 13:26:05 # at 79 #030331 13:31:33 server id 1 log_pos 79 Query thread_id=19 exec_time=0 error_code=0 use escribaupdate; SET TIMESTAMP=1049128296; delete from atualiza_autorizacao;
the command is write to LOGBIN file only if i logged in database escribaupdate... this is a bug... because i modify the database escribaupdate from database mysql and this is not logged...
is a bug ?
Tnks in advance.
sql,query,bug,help !!!!
-------------------------------------------------------------------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento -------------------------------------------------------------------------
E S C R I B A I N F O R M A T I C A
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- ICQ : 221602060 $ look into "my eyes" Phone : +55 041 296-2311 r.112 look: cannot open my eyes Fax : +55 041 296-6640 -------------------------------------------------------------------------
Reply: [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
