Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +------------------+----------+---------------------+------------------+-------------------+
- | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
- +------------------+----------+---------------------+------------------+-------------------+
- | mysql-bin.000001 | 713473 | some_database | | |
- +------------------+----------+---------------------+------------------+-------------------+
- 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;
- 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'.
- 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
- 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
- mysql --host=xxx.xxx.xxx.xx --port=3306 --user=my_slave --password=my_slave_password!
- Welcome to the MySQL monitor. Commands end with ; or g.
- Your MySQL connection id is 29
- Server version: 5.7.15 MySQL Community Server (GPL)
- Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
- Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
- mysql>
- 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
- mysql --host=xxx.xxx.xxx.xx --port=3306 --user=root --password=slave_root_password < c:dumpsall_db.sql
- mysql> start slave;
Add Comment
Please, Sign In to add comment