首页 > 数据库技术 > 详细

mysql 启动不了了

时间:2017-01-03 18:52:49      阅读:769      评论:0      收藏:0      [点我收藏+]

在做测试的工程中,发现mysql启动失败,报错信息如下:

2017-01-03T08:19:19.969163Z mysqld_safe mysqld from pid file /var/data/my3306/run/mysqld.pid ended
2017-01-03T08:19:51.304099Z mysqld_safe Starting mysqld daemon with databases from /var/data/my3306/data
2017-01-03T08:19:51.435091Z 0 [Warning] The syntax --log_warnings/-W is deprecated and will be removed in a future release. Please use --log_error_verbosity instead.
2017-01-03T08:19:51.435154Z 0 [Warning] The syntax --metadata_locks_hash_instances is deprecated and will be removed in a future release
2017-01-03T08:19:51.435161Z 0 [Warning] The syntax --metadata_locks_cache_size is deprecated and will be removed in a future release
2017-01-03T08:19:51.435208Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-03T08:19:51.435232Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2017-01-03T08:19:51.438636Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.
html
2017-01-03T08:19:51.856517Z 0 [ERROR] InnoDB: Log block 190938946 at lsn 97760739840 has valid header, but checksum field contains 3735928559, should be 3356345455
2017-01-03T08:19:51.856549Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 97760740287 and the end 97760739840.
2017-01-03T08:19:51.856565Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-01-03T08:19:52.456983Z 0 [ERROR] Plugin InnoDB init function returned error.
2017-01-03T08:19:52.457013Z 0 [ERROR] Plugin InnoDB registration as a STORAGE ENGINE failed.
2017-01-03T08:19:52.457021Z 0 [ERROR] Failed to initialize plugins.
2017-01-03T08:19:52.457027Z 0 [ERROR] Aborting

解决办法呢是从网上搜到的“双胞胎拔比”的连接:

也是参考网上的:Solved
http://spin.atomicobject.com/2011/05/09/mysql-failed-registration-of-innodb-as-a-storage-engine/ 

Rename or move both the ./ib_logfile0 and ./ib_logfile1 files, and then start the MySQL server.

 

mysql 启动不了了

原文:http://www.cnblogs.com/sunss/p/6245403.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!