----- Original Message ----- From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 29, 2004 3:54 PM Subject: Re: replication in mysql5 between linux and windows
> Jonas Lind?n <[EMAIL PROTECTED]> wrote: > > Hello list, I have successfully installed mysql5 on my windows box and my aim is set on replicating my mysql5 linux system. I think I am on the right track and the systems seem to talk to eachother according to my logs. My problem is that nothing is replicated in my databases but I think that the replication position pointer is increasing. My conclusion is that something is replicated but not add to my databases? > > > > This is a snippet from my mysql.err log on my windows box which to me seem to replicate something. If I add data to my linux mysql database and then restart the windows mysql system it seems that the log file has increased? > > > > > >My mysql.err file on my windows box at startup before updating. > > > > 040329 11:20:03 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3307', replication started in log 'lavazza-bin.000004' at position 60801 > > > > Adding something on my linux box and the restarting my windows mysql database I recive this in my mysq.err > > > > 040329 11:28:41 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3307', replication started in log 'lavazza-bin.000004' at position 112037 > > > > To me it seems that something has increased the log position pointer? But my database has not been updated. Has anyone a suggestion to what might be the reason for my problem? > > > > Could my problem be that I am running InnoDB tables? I successfully managed to update my slave tables with "LOAD DATA FROM MASTER" so there is some kind of connection between the two atleast. > > Show the output of SHOW SLAVE STATUS command. > What replication options do you use? > > Hello this is my "show slave status". What replicatin options I use? well I want to replicate everything which I think I am doing but I havent explicitly noted that any where. Where do I set my replication options? regards /Jonas mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: Master_Host: lavazza.mydomin.com Master_User: repl Master_Port: 3307 Connect_Retry: 60 Master_Log_File: lavazza-bin.000006 Read_Master_Log_Pos: 95 Relay_Log_File: jonas-relay-bin.000009 Relay_Log_Pos: 231 Relay_Master_Log_File: lavazza-bin.000006 Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_Do_DB: myDB Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 95 Relay_Log_Space: 136 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 16013 1 row in set (0.00 sec) ERROR: No query specified -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]