Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Once imported, configure slave DB server replication. In the command below, replace MASTER_SERVER, REPLICA_USER and REPLICA_PASS.
Also replace  MASTER_LOG_FILE and MASTER_LOG_POS from the show master status (e.g. from above  "master-bin.000001" and  "3712878") . 
Run this command on the slave server at the mysql prompt:

Code Block
change master to
  MASTER_HOST='MASTER_SERVER',
  MASTER_USER='REPLICA_USER',
  MASTER_PASSWORD='REPLICA_PASS',
  MASTER_PORT=3306,
  MASTER_LOG_FILE='MASTER_LOG_FILE',
  MASTER_LOG_POS='MASTER_LOG_POS',
  MASTER_CONNECT_RETRY=10;

...