MySQL复制ERROR 1794 (HY000): Slave is not configured or failed to initialize properly.

最新推荐文章于 2023-03-30 11:03:12 发布

aecuhty88306453

最新推荐文章于 2023-03-30 11:03:12 发布

阅读量2.1k

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/DataArt/p/10260970.html

版权

本文详细记录了MySQL复制过程中遇到ERROR1794的解决方案，包括删除并重建特定的InnoDB表，如slave_master_info、slave_relay_log_info等，以及重启数据库和服务的步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ERROR 1794 (HY000): Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave. Additional error messages can be found in 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表

 
          use mysql 
         
          drop table slave_master_info; 
         
          drop table slave_relay_log_info; 
         
          drop table slave_worker_info; 
         
          drop table innodb_index_stats; 
         
          drop table innodb_table_stats;

2、重建

 
          mysql> source /usr/local/mysql/share/mysql_system_tables.sql 
         
          Query OK, 0 rows affected, 1 warning (0.00 sec)

3、重启数据库

 
          [root@mysql01 data]# usr/local/mysql/bin/mysqld restart 
         
          Shutting down MySQL..                                      [  OK  ] 
         
          Starting MySQL..                                           [  OK  ]