Error: data file /data/ibdata/ibdata1 is of a different size

090625 22:42:38 mysqld started

InnoDB: Error: data file /data/ibdata/ibdata1 is of a different size

InnoDB: 65536 pages (rounded down to MB)

InnoDB: than specified in the .cnf file 640 pages!

InnoDB: Could not open or create data files.

InnoDB: If you tried to add new data files, and it failed here,

InnoDB: you should now edit innodb_data_file_path in my.cnf back

InnoDB: to what it was, and remove the new ibdata files InnoDB created

InnoDB: in this failed attempt. InnoDB only wrote those files full of

InnoDB: zeros, but did not yet use them in any way. But be careful: do not

InnoDB: remove old data files which contain your precious data!

090625 22:42:39 [ERROR] Default storage engine (InnoDB) is not available

解決：把innodb_data_file_path=ibdata1:1G;ibdata2:1G:autoextend設為正确的值

二、Error 'Duplicate entry '807370' for key

090625 22:56:33 [Note] Slave SQL thread initialized, starting replication in log 'fb-bin.000099' at position 152, relay log './fb-re

lay.000403' position: 179125349

090625 22:56:35 [ERROR] Slave: Error 'Duplicate entry '807370' for key 1' on query. Default database: 'fb'. Query: 'insert into doin

g (userid, content, dtime) values (700018757, '曛1m~Y′曛1m~\~W', now())', Error_code: 1062

090625 23:00:58 [Note] Slave I/O thread exiting, read up to log 'fb-bin.000007', position 890371603

090625 23:04:23 [Note] Slave SQL thread initialized, starting replication in log 'fb-bin.000099' at position 179125745, relay log '.

/fb-relay.000001' position: 4

本文轉自holy2009 51CTO部落格，原文連結:http://blog.51cto.com/holy2010/367869