Restart slave DB server replicating

ssh ec2-user@54.164.68.22
ssh ec2-user@54.174.76.210
mysql -u root -p
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