views:

68

answers:

2
  mysql> show slave status\G;
  *************************** 1. row ***************************
               Slave_IO_State: Connecting to master
                  Master_Host: 10.0.6.55
                  Master_User: slave_user
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000026
          Read_Master_Log_Pos: 106
               Relay_Log_File: Praetorian-PC-relay-bin.000004
                Relay_Log_Pos: 98
        Relay_Master_Log_File: mysql-bin.000026
             Slave_IO_Running: No
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          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: 106
              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.02 sec)
  ERROR:
  No query specified
  mysql>

The slave is not updating when the master has been updated.... also the line (Slave_IO_Running: No) why is it saying no

A: 

It looks as though there may not be connectivity between the slave and master. The Slave_IO_State suggests MySQL is having trouble connecting. Try to connect to the master from the command line.

Chris Henry
A: 

I have done everything from the command line and this still shows.... I am using vmware virtual machine to interact with my host system, the host is the master and the virtual machine is the slave....

anything that may help will be greatly appreciated...

Allan