12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间：2024-12-24 19:11:25
作者：文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
MySQL异机迁移后，启动数据库报错#/data/mysql_57_software/bin/mysqld_safe--defaults-file=/etc/my3319.cnf--user=mysql&#tail-20/var/log/mysqld3319.log2019-01-02T07:11
以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。
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
将本文的Word文档下载到电脑
推荐度：
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19