• InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!


    问题描述:

      centos 安装MySQL

      $yum install mysql-server
      安装之后执行命令mysql

      报错:

      查看mysql的启动日志:

    [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
    2016-02-22 23:02:55 29830 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
    2016-02-22 23:02:55 29830 [ERROR] Plugin 'InnoDB' init function returned error.
    2016-02-22 23:02:55 29830 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2016-02-22 23:02:55 29830 [ERROR] Unknown/unsupported storage engine: InnoDB
    2016-02-22 23:02:55 29830 [ERROR] Aborting
    解决方法:

     执行删除命令:rm -rf /var/lib/mysql/ib*

    删除:ibdata1、ib_logfile0、ib_logfile1文件

    重新启动:service mysqld start

  • 相关阅读:
    mybatis开始
    14-spring学习-变量操作
    java动态加载jar文件
    Linux下不借助工具实现远程linux服务器上传下载文件
    UML入门
    Linux下打开超大文件的方法
    List和Array相互转换
    redis常用命令
    redis不支持多个数据库实例但是支持多个字典
    如何配置 VirtualBox 中的客户机与宿主机之间的网络连接
  • 原文地址:https://www.cnblogs.com/sagech/p/5207303.html
Copyright © 2020-2023  润新知