innodb_data_file_path初始化太大引起的错误

朋友升级了库，但是启库的时候 却报错了，根据他的报错猜想应该是 innodb_data_file_path的问题，就把自己库的innodb_data_file_path初始化大小加大，报错如下，重现了朋友的错误

2015-04-24 19:37:51 3628 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 4864 pages (rounded down to MB) than specified in the .cnf file: initial 6400 pages, max 0 (relevant if non-zero) pages!

2015-04-24 19:37:51 3628 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!

当迁移或升级过程中 启动数据库报这个错误时，是因为  innodb_data_file_path中指定的初始大小 比现在的 ibdata文件还要大。通过改小值避免这个错误

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25099483/viewspace-1596475/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25099483/viewspace-1596475/