Did you start from position Exec_Master_Log_Pos 1?  Can you tell us the
command you used to get this going?

Mike

On Mon, Jul 28, 2008 at 4:14 PM, Bryan Irvine <[EMAIL PROTECTED]> wrote:

> I'm having an issue setting up a slave Where it doesn't seem to start:
>
> mysql> show master status;
> +------------------+----------+--------------+------------------+
> | File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
> +------------------+----------+--------------+------------------+
> | mysql-bin.000044 |       98 | exampledb    |                  |
> +------------------+----------+--------------+------------------+
> 1 row in set (0.00 sec)
>
> mysql> show slave status\G;
> *************************** 1. row ***************************
>             Slave_IO_State:
>                Master_Host: 192.168.1.161
>                Master_User: slave2
>                Master_Port: 3306
>              Connect_Retry: 60
>            Master_Log_File: mysql-bin.000044
>        Read_Master_Log_Pos: 98
>             Relay_Log_File: slave-relay.000001
>              Relay_Log_Pos: 98
>      Relay_Master_Log_File: mysql-bin.000044
>           Slave_IO_Running: No
>          Slave_SQL_Running: Yes
>            Replicate_Do_DB: exampledb
>        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: 98
>            Relay_Log_Space: 98
>            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: NULL
> 1 row in set (0.00 sec)
>
> ERROR:
> No query specified
>
> mysql>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
>
>

Reply via email to