Hi all,


Due to disk space limit i deleted several logs, and slave was stop at that movement. now i want to update slave , can i do that ?



Code:
mysql> show slave status \G
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: 10.10.10.1
                Master_User: slaveuser
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: mysql-bin.000102
        Read_Master_Log_Pos: 387296687
             Relay_Log_File: dbrep-relay-bin.000063
              Relay_Log_Pos: 235
      Relay_Master_Log_File: mysql-bin.000089
           Slave_IO_Running: Yes
          Slave_SQL_Running: No
            Replicate_Do_DB:
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 2
                 Last_Error: Error in Append_block event: could not open file '/tmp/SQL_LOAD-2-1-0.data'
               Skip_Counter: 0
        Exec_Master_Log_Pos: 112294655
            Relay_Log_Space: 7421092446
            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.06 sec)
can i force slave to start using from master log "mysql-bin.000090", if yes then how do i get position of this file ?

thanks