User Tools

Writing /var/www/html/wiki.freefm.uk/data/log/deprecated/2025-12-16.log failed

Mysql Replicator helpers

Master Side

Get current status and position: 

SHOW MASTER STATUS\G
or 
show master status;

Slave Side

First time (I think) should be: 

CHANGE MASTER TO MASTER_HOST='10.20.10.1', MASTER_USER='user', MASTER_PASSWORD='password', MASTER_LOG_FILE='master1-bin.000004', MASTER_LOG_POS=8044078;

Change file and position: 

CHANGE MASTER TO MASTER_LOG_FILE='master1-bin.000004', MASTER_LOG_POS=8044078;