SHARE
TWEET

Untitled

a guest Jun 18th, 2019 52 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SHOW MASTER STATUS;
  2. Copied the values of MASTER_LOG_FILE and MASTER_LOG_POS.
  3.      
  4. STOP SLAVE;
  5. RESET SLAVE;
  6. CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=98; (<- example values)
  7. START SLAVE;
  8. SHOW SLAVE STATUS G;
  9.      
  10. Slave_IO_State  Waiting for master to send event
  11. Master_Host xxx.xxx.xxx.xxx
  12. Master_User repl
  13. Master_Port 3306
  14. Connect_Retry   60
  15. Master_Log_File mysql-bin.000006
  16. Read_Master_Log_Pos 787956776
  17. Relay_Log_File  mysql-relay-bin.000004
  18. Relay_Log_Pos   624412
  19. Relay_Master_Log_File   mysql-bin.000006
  20. Slave_IO_Running    Yes
  21. Slave_SQL_Running   Yes
  22. Replicate_Do_DB
  23. Replicate_Ignore_DB
  24. Replicate_Do_Table  
  25. Replicate_Ignore_Table  
  26. Replicate_Wild_Do_Table
  27. Replicate_Wild_Ignore_Table
  28. Last_Errno  0
  29. Last_Error  
  30. Skip_Counter    0
  31. Exec_Master_Log_Pos 787956776
  32. Relay_Log_Space 788197
  33. Until_Condition None
  34. Until_Log_File  
  35. Until_Log_Pos   0
  36. Master_SSL_Allowed  No
  37. Master_SSL_CA_File  
  38. Master_SSL_CA_Path  
  39. Master_SSL_Cert
  40. Master_SSL_Cipher  
  41. Master_SSL_Key  
  42. Seconds_Behind_Master   0
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top