倒库

发布时间 2023-05-22 10:27:43作者: 哦~杰克

 

master:

mysqldump -uroot -p --databases perceive >/app/backup/perceive.sql

tar -zcvf mysql.tar perceive.sql

slave : 

stop slave;
CHANGE MASTER TO
MASTER_HOST='192.168.0.184',
MASTER_PORT=2206,
MASTER_USER='root',
MASTER_PASSWORD='passwd',

MASTER_LOG_FILE='mysql-bin.000012',

MASTER_LOG_POS=424494537;

start slave;