mysql启动的报错

linux底下使用rpm安装mysql报错,查看错误日志，报错第一行如下：InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!

检查发现mysql的目录下有如下文件：

[root@tserver mysql]# ls
ibdata1  ib_logfile0  ib_logfile1  mysql  RPM_UPGRADE_HISTORY  RPM_UPGRADE_MARKER-LAST  test  tserver.err

删除了如下三个文件：

[root@tserver mysql]# rm ibdata1  ib_logfile0  ib_logfile1
rm: remove regular file `ibdata1'? yes      
rm: remove regular file `ib_logfile0'? yes
rm: remove regular file `ib_logfile1'? yes

重新启动mysql server就可以了：

[root@tserver mysql]# /etc/init.d/mysql start
Starting MySQL.[  OK  ]

转载自http://marvelyu.blog.51cto.com/471030/1353288