the step:
- stop slave;
- change master to master_host=’server_ip’, master_log_file=’the bin-log file on the master server’, master_log_pos=the position of the bin-log file;
- start slvae;
how to find the correct bin-log file and its position number?
on myster server, type this command
show master status;
you will get the information you wanted by the mysql server.
change master server on a slave mysql server
