- 论坛徽章:
- 0
|
本帖最后由 ssshenan2008 于 2013-08-12 14:19 编辑
之前做主从
我是直接把主数据库的MySQLData和MySqlBinlog 这两个目录 复制到从数据库
两台机子的mysql版本都是mysql-essential-5.1.57-winx64
现在备机的mysql服务,经常崩溃掉。
我开启错误日志,发现出来下面的错误,请问一下要怎么解决呢?- 130812 13:58:25 [Note] Slave SQL thread initialized, starting replication in log 'binlog.000038' at position 657029285, relay log '.\mysql-relay-bin.000086' position: 177887824
- 130812 13:58:25 [Note] Slave I/O thread: connected to master 'username@ip:port',replication started in log 'binlog.000039' at position 1051225285
- 130812 13:58:26 [ERROR] Index Idx_MoneyExLog_User of userserver/moneyexlog has 2 columns unique inside InnoDB, but MySQL is asking statistics for 3 columns. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
- 130812 13:58:28 [ERROR] Table userserver/loginlog contains fewer indexes inside InnoDB than are defined in the MySQL .frm file. Have you mixed up .frm files from different installations? See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
复制代码 |
|