Resyncing a Primary from a Backup Server

When a primary server is out of sync with its backup, you can manually resync the primary.

Procedure

  1. Stop primary server P.
  2. Back up the database at B.
    The result is a zip file.
  3. Replace the database files on P with the contents of that zip file:
    1. Copy the zip file to the primary’s host computer.
    2. Navigate to the data folder for P.
      See --data.
    3. Extract the contents of the zip file into the data folder, overwriting existing files.

      This operation overwrites some of the existing database files, but not all of them.

  4. Restart P.