Restart slave DB server replicating
ssh ec2-user@54.164.68.22
mysql -u root -p
234
show slave status\G;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER =1;
start slave;
Dump SQL tables
Import sql
ssh ec2-user@54.174.76.210
234
show slave status\G;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER =1;
start slave;
Dump SQL tables
Import sql
mysql -u username -p database_name < file.sql
Comments