Page History

...

The database that is out of sync is on Server2, therefore, you are going to take a snapshot of the database from Server1, then restore the snapshot onto Server-2 Server2 and restart the replication.

...

mysql -u root -p

(Enter your password at prompt)

mysql> use dualshield;

mysql> stop slave;

Take a snapshot of the database on Server1

...

Hit return and enter the password when prompted.  Hit return again.  The process may take a few minutes, but when you see the curser cursor again, it means the snapshot has been taken.

...

mysql> stopstart slave;

Check slave status on both servers:

...