Guest User

Untitled

a guest
Dec 15th, 2018
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.01 KB | None | 0 0
  1. +------------------+----------+---------------------+------------------+-------------------+
  2. | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
  3. +------------------+----------+---------------------+------------------+-------------------+
  4. | mysql-bin.000001 | 713473 | some_database | | |
  5. +------------------+----------+---------------------+------------------+-------------------+
  6.  
  7. CHANGE MASTER TO MASTER_HOST='xxx.xxx.xxx.xx', MASTER_USER='my_slave', MASTER_PASSWORD='my_slave_password!', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=713473;
  8.  
  9. 170529 2:14:00 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='xxx.xxx.xxx.xx', master_port='3306', master_log_file='mysql-bin.000001', master_log_pos='713473'.
  10. 170529 2:14:42 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000001' at position 713473, relay log './mysql-relay-bin.000001' position: 4
  11. 170529 2:14:42 [ERROR] Slave I/O: error connecting to master 'my_slave@xxx.xxx.xxx.xx:3306' - retry-time: 60 retries: 86400, Error_code: 1130
  12.  
  13. mysql --host=xxx.xxx.xxx.xx --port=3306 --user=my_slave --password=my_slave_password!
  14.  
  15. Welcome to the MySQL monitor. Commands end with ; or g.
  16. Your MySQL connection id is 29
  17. Server version: 5.7.15 MySQL Community Server (GPL)
  18.  
  19. Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
  20.  
  21. Oracle is a registered trademark of Oracle Corporation and/or its
  22. affiliates. Other names may be trademarks of their respective
  23. owners.
  24.  
  25. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
  26. mysql>
  27.  
  28. mysqldump --host=xxx.xxx.xxx.xx --port=3306 --user=my_slave --password=my_slave_password! --single-transaction --master-data=1 --all-databases > c:dumpsall_db.sql
  29.  
  30. mysql --host=xxx.xxx.xxx.xx --port=3306 --user=root --password=slave_root_password < c:dumpsall_db.sql
  31.  
  32. mysql> start slave;
Add Comment
Please, Sign In to add comment