Restart Replication After Master Reload

[Matt]

Code: [Select]

STOP SLAVE;

Code: [Select]

FLUSH TABLES WITH READ LOCK;

Code: [Select]

SHOW MASTER STATUS; (record these valuse it will state name of file and position)

Code: [Select]

UNLOCKTABLES;

Code: [Select]

CHANGE MASTER TO MASTER_LOG_FILE='recorded_log_file_name',
CHANGE MASTER TO MASTER_LOG_POS=recorded_log_position;

Code: [Select]

START SLAVE;