MySQL master-Slave synchronization complete Command

Main Library Operations

1. Read-only lock for the master library

Flush tables with read lock;

2. Export data from the main library

Mysqldump-h120.92.20.125-u admin-p--all-databases >event-manager.sql

3. View the main library binary log information

Show Master Status Note the binary log file name and location

4. Unlocking the main library

Unlock tables

Operation from Library

1. Import data from the Event-manager.sql file of the main library

Mysql-uroot-p < Event-manager.sql

2. Go to execute from library

Mysql-uroot-p

>stop slave;

>change Master to master_host= ' 120.92.20.125 ', master_port=53895,master_user= ' Awsabroadrepl ', master_password= ' Qakcc8imkjgbhqlc ', master_log_file= ' binlog.001178 ', master_log_pos= ' 55981780 ';

>start slave;

>show slave status;

MySQL master-Slave synchronization complete Command