• MySQL Plugin 'InnoDB' init function returned error


     

    . . 在MySQL的配置文件中,设定default-table-type=InnoDB,发现MySQL无法正常的启动,错误日志中给出了如下的信息: 

    150210 18:11:19 mysqld_safe mysqld from pid file /data/mysqldata/mysql.pid ended
    150210 18:15:20 mysqld_safe Starting mysqld daemon with databases from /data/mysqldata
    150210 18:15:20 InnoDB: The InnoDB memory heap is disabled
    150210 18:15:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    150210 18:15:20 InnoDB: Compressed tables use zlib 1.2.3
    150210 18:15:20 InnoDB: Initializing buffer pool, size = 128.0M
    150210 18:15:20 InnoDB: Completed initialization of buffer pool
    150210 18:15:20 InnoDB: highest supported file format is Barracuda.
    InnoDB: No valid checkpoint found.
    InnoDB: If this error appears when you are creating an InnoDB database,
    InnoDB: the problem may be that during an earlier attempt you managed
    InnoDB: to create the InnoDB data files, but log file creation failed.
    InnoDB: If that is the case, please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.5/en/error-creating-innodb.html
    150210 18:15:20 [ERROR] Plugin 'InnoDB' init function returned error.
    150210 18:15:20 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    150210 18:15:20 [ERROR] Unknown/unsupported storage engine: InnoDB
    150210 18:15:20 [ERROR] Aborting



    在网上查找后,只要删除MySQL目录下的ib_logfile0和ib_logfile1和ibdata1就可以了,只删除前两个还是不行,得都删除才可以,我测试的时候是这样

  • 相关阅读:
    振动传感器
    水银开关式碰撞传感器
    倾斜传感器
    光敏传感器
    激光传感器的使用
    html字符串 转 json
    浏览器播放视频加快进功能
    处理箭头函数单个参数括号规则冲突
    VUE-directive指令之语法、引用、钩子函数、参数
    win10系统自动升级怎么还原到以前的系统
  • 原文地址:https://www.cnblogs.com/z-books/p/4284583.html
Copyright © 2020-2023  润新知