mysql从库宕机重启恢复

参考博客

已安装 MySQL，但执行 mysql 命令提示命令找不到！

解决Mysql 主从或主主报1062错误

---

mysql命令失效

vim /etc/profile

export PATH = $PATH:/usr/local/mysql/bin

source /etc/profile

mysql从库主键冲突

单行跳过

stop slave; 
set global sql_slave_skip_counter =1;
start slave;
show slave status/G;

批量跳过

vim /etc/my.cnf

slave-skip-errors = 1062

service mysql restart