mysql 1794错误_MySQL复制ERROR 1794 (HY000): Slave is not configured or failed to initialize properly....
ERROR 1794 (HY000): Slaveisnot configured or failed to initialize properly. You must at leastset--server-id to enable either a master or a slave. Additional error messages can be foundinthe MySQL e...
ERROR 1794 (HY000): Slaveis not configured or failed to initialize properly. You must at leastset --server-id to enable either a master or a slave. Additional error messages can be foundin the MySQL error log.
error log中有类似日志:
2016-05-10 17:21:25 14407 [Warning] InnoDB: Cannot open table mysql/innodb_table_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. See
http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-05-10 17:21:25 14407 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See
http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-05-10 17:21:25 14407 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See
http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2016-05-10 17:21:25 14407 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See
http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
解决步骤:
1、drop 备份的 ibd表
2、重建
3、重启数据库
至此,问题解决,登陆数据库,重新 change master to 即可!
原文:https://www.cnblogs.com/DataArt/p/10260970.html
更多推荐
所有评论(0)