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]
