MySQL异机迁移后，启动数据库报错

#/data/mysql_57_software/bin/mysqld_safe--defaults-file=/etc/my3319.cnf--user=mysql&#tail-20/var/log/mysqld3319.log2019-01-02T07:11:01.716793Z0[ERROR]InnoDB:Theinnodb_systemdatafile'./ibdata1'isofadifferentsize17152pages(roundeddowntoMB)thanthe64000pagesspecifiedinthe.cnffile!2019-01-02T07:11:01.716832Z0[ERROR]InnoDB:PlugininitializationabortedwitherrorGenericerror2019-01-02T07:11:02.317322Z0[ERROR]Plugin'InnoDB'initfunctionreturnederror.2019-01-02T07:11:02.317347Z0[ERROR]Plugin'InnoDB'registrationasaSTORAGEENGINEfailed.2019-01-02T07:11:02.317353Z0[ERROR]Failedtoinitializeplugins.2019-01-02T07:11:02.317361Z0[ERROR]Aborting


报错原因：

参数文件中的系统表空间大于实际的系统表空间大小，导致启动报错。

#du-sh/data/mysql_3319/ibdata1268M/data/mysql_3319/ibdata1#cat/etc/my3319.cnf#innodbinnodb_data_file_path=ibdata1:1000M;ibdata2:1000M:autoextend


解决办法：

将参数文件中系统表空间的大小改为小于实际系统表空间大小的值。

#innodbinnodb_data_file_path=ibdata1:256M;ibdata2:256M:autoextend