Vuelvo a mandar un Estado nuevo cuando hago SHOW SLAVE STATUS;
<field name="Slave_IO_State">Waiting for master to send event</field>
<field name="Master_Host">192.168.1.35</field>
<field name="Master_User">root</field>
<field name="Master_Port">3307</field>
<field name="Connect_Retry">60</field>
<field name="Master_Log_File">mysql-bin.000003</field>
<field name="Read_Master_Log_Pos">106</field>
<field name="Relay_Log_File">RocarServer-PC-relay-bin.000008</field>
<field name="Relay_Log_Pos">251</field>
<field name="Relay_Master_Log_File">mysql-bin.000003</field>
<field name="Slave_IO_Running">Yes</field>
<field name="Slave_SQL_Running">Yes</field>
<field name="Replicate_Do_DB">qreplication</field>
<field name="Replicate_Ignore_DB"></field>
<field name="Replicate_Do_Table"></field>
<field name="Replicate_Ignore_Table"></field>
<field name="Replicate_Wild_Do_Table"></field>
<field name="Replicate_Wild_Ignore_Table"></field>
<field name="Last_Errno">0</field>
<field name="Last_Error"></field>
<field name="Skip_Counter">0</field>
<field name="Exec_Master_Log_Pos">106</field>
<field name="Relay_Log_Space">560</field>
<field name="Until_Condition">None</field>
<field name="Until_Log_File"></field>
<field name="Until_Log_Pos">0</field>
<field name="Master_SSL_Allowed">No</field>
<field name="Master_SSL_CA_File"></field>
<field name="Master_SSL_CA_Path"></field>
<field name="Master_SSL_Cert"></field>
<field name="Master_SSL_Cipher"></field>
<field name="Master_SSL_Key"></field>
<field name="Seconds_Behind_Master">0</field>
<field name="Master_SSL_Verify_Server_Cert">No</field>
<field name="Last_IO_Errno">0</field>
<field name="Last_IO_Error"></field>
<field name="Last_SQL_Errno">0</field>
<field name="Last_SQL_Error"></field>
----- Original Message -----
From: "Juan Vallini" <Juan_Vallini@stripped>
To: "auxion.de - Technik" <technik@stripped>; <mysql-es@stripped>
Sent: Friday, February 22, 2013 11:38 AM
Subject: Re: Sigo con problemas de Replication
> Ok. Como Cambio ese parametro??
>
> Gracias
>
> ----- Original Message -----
> From: "auxion.de - Technik" <technik@stripped>
> To: "'Juan Vallini'" <Juan_Vallini@stripped>;
> <mysql-es@stripped>
> Sent: Friday, February 22, 2013 11:29 AM
> Subject: AW: Sigo con problemas de Replication
>
>
> hOLA jUAN,
>
> Puede ser que mysql-bin.001 no concuerda con la estructura que tienes en
> tu
> Master: mysql-bin.000002
>
> Saludos
> Thomas
>
> -----Ursprüngliche Nachricht-----
> Von: Juan Vallini [mailto:Juan_Vallini@stripped]
> Gesendet: Freitag, 22. Februar 2013 14:58
> An: mysql-es@stripped
> Betreff: Sigo con problemas de Replication
>
> Foro:
>
> Sigo teniendo problemas para poder replicar. Dejo el Show master status
> y el Show slave status para ver si podemos solucionarlo
>
>
> SHOW SLAVE STATUS;
> <row>
> <field name="Slave_IO_State"></field>
> <field name="Master_Host">192.168.1.35</field>
> <field name="Master_User">root</field>
> <field name="Master_Port">3307</field>
> <field name="Connect_Retry">60</field>
> <field name="Master_Log_File">mysql-bin.001</field>
> <field name="Read_Master_Log_Pos">106</field>
> <field
> name="Relay_Log_File">RocarServer-PC-relay-bin.000003</field>
> <field name="Relay_Log_Pos">4</field>
> <field name="Relay_Master_Log_File">mysql-bin.001</field>
> <field name="Slave_IO_Running">No</field>
> <field name="Slave_SQL_Running">Yes</field>
> <field name="Replicate_Do_DB">qreplication</field>
> <field name="Replicate_Ignore_DB"></field>
> <field name="Replicate_Do_Table"></field>
> <field name="Replicate_Ignore_Table"></field>
> <field name="Replicate_Wild_Do_Table"></field>
> <field name="Replicate_Wild_Ignore_Table"></field>
> <field name="Last_Errno">0</field>
> <field name="Last_Error"></field>
> <field name="Skip_Counter">0</field>
> <field name="Exec_Master_Log_Pos">106</field>
> <field name="Relay_Log_Space">106</field>
> <field name="Until_Condition">None</field>
> <field name="Until_Log_File"></field>
> <field name="Until_Log_Pos">0</field>
> <field name="Master_SSL_Allowed">No</field>
> <field name="Master_SSL_CA_File"></field>
> <field name="Master_SSL_CA_Path"></field>
> <field name="Master_SSL_Cert"></field>
> <field name="Master_SSL_Cipher"></field>
> <field name="Master_SSL_Key"></field>
> <field name="Seconds_Behind_Master" xsi:nil="true" />
> <field name="Master_SSL_Verify_Server_Cert">No</field>
> <field name="Last_IO_Errno">1236</field>
> <field name="Last_IO_Error">Got fatal error 1236 from master when
> reading data from binary log: 'Could not find first log file name in
> binary
> log index file'</field>
> <field name="Last_SQL_Errno">0</field>
> <field name="Last_SQL_Error"></field>
> </row>
>
>
> SHOW MASTER STATUS;
> <row>
> <field name="File">mysql-bin.000002</field>
> <field name="Position">106</field>
> <field name="Binlog_Do_DB">QReplication</field>
> <field name="Binlog_Ignore_DB"></field>
> </row>
>
> SALUDOS
>
>
> --
> Lista de Correos de MySQL
> Para el historial de la lista: http://lists.mysql.com/mysql-es
> Para cancelar inscripción: http://lists.mysql.com/mysql-es
>
>
> --
> Lista de Correos de MySQL
> Para el historial de la lista: http://lists.mysql.com/mysql-es
> Para cancelar inscripción: http://lists.mysql.com/mysql-es
>
