![MySQL调整innodb_page_size之后出现[ERROR] InnoDB: Data file /data/mysql/poweridc/data/ibdata1 is of a different size xxx pages](https://gkxyz.com/wp-content/themes/uzi_twentytwentyfour/images/default-placeholder-300x300.webp "MySQL调整innodb_page_size之后出现[ERROR] InnoDB: Data file /data/mysql/poweridc/data/ibdata1 is of a different size xxx pages")
问题描述
我们在使用 mysql < 迁移导入命令时出现了 Row size too large (> 8126) 的问题，具体错误如下：
ERROR 1118 (42000) at line 19021: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
然后我们试图解决问题，修改 innodb_page_size 值。但是之前数据库已创建并启动，我们修改了之后导致值不相同了，所以才会出现如下错误：
InnoDB: The innodb_system data file ‘./ibdata1’ is of a different
解决办法
进入到数据库存储位置的对应的数据库的mysql文件夹，将 ib_logfile0 、 ib_logfile1 、 ibdata1 等类似的文件删除，重启数据库即可。
cd /data/mysql/ rm ib_logfile0 -rf rm ib_logfile1 -rf rm ibdata1 -rf /etc/init.d/mysql restart![MySQL调整innodb_page_size之后出现[ERROR] InnoDB: Data file /data/mysql/poweridc/data/ibdata1 is of a different size xxx pages](http://jiloc.com/wp-content/uploads/2021/05/uooz-it-wechat-e1622017038500.png "MySQL调整innodb_page_size之后出现[ERROR] InnoDB: Data file /data/mysql/poweridc/data/ibdata1 is of a different size xxx pages")
评论已关闭