InnoDB: The log sequence number in ibdata files does not match
InnoDB的:在ibdata文件的日志序列号不匹配
可能ibdata文件损坏了
解决办法如下:
在my.cny 的[mysqld]中加入
# Size of each log file in a log group. You should set the combined size
# of log files to about 25%-100% of your buffer pool size to avoid
# unneeded buffer pool flush activity on log file overwrite. However,
# note that a larger logfile size will increase the time needed for the
# recovery process.
innodb_log_file_size=10M
# Number of threads allowed inside the InnoDB kernel. The optimal value
# depends highly on the application, hardware as well as the OS
#
scheduler properties. A too high value may lead to thread thrashing.
innodb_thread_concurrency=8
innodb_force_recovery = 4
max_allowed_packet=16M