service mysqld stop
cd /var/lib/mysql/
mv auto.cnf auto.cnf_bak
vim /etc/my.cnf
service mysqld start
mysql -u root -p'password'
show slave status\G
stop slave;
reset slave;
CHANGE MASTER TO
MASTER_LOG_FILE='mysql-bin.008264', <<-- Take Own Server Log Bin
MASTER_LOG_POS=717525205; <<-- Take Own Server Log Position
start slave;
show slave status\G
No comments:
Post a Comment