----- 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]
