mysql的問題

ssshenan2008

之前做主從
我是直接把主數據庫的MySQLData和MySqlBinlog 這兩個目錄 復制到從數據庫
兩臺機子的mysql版本都是mysql-essential-5.1.57-winx64
現在備機的mysql服務，經常崩潰掉。
我開啟錯誤日志，發(fā)現出來下面的錯誤，請問一下要怎么解決呢？

1. 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
   
2. 130812 13:58:25 [Note] Slave I/O thread: connected to master 'username@ip:port',replication started in log 'binlog.000039' at position 1051225285
   
3. 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
   
4. 
   
5. 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

復制代碼

chinafenghao

你拷貝數據是否停機拷貝？