您的位置:68399皇家赌场 > 虚拟主机 > 【澳门皇家赌场55533网址】mysql InnoDB数据不可能起

【澳门皇家赌场55533网址】mysql InnoDB数据不可能起

发布时间:2019-07-07 00:02编辑:虚拟主机浏览(170)

    090613 10:30:12 [Note] C:wwwmysqlbinmysqld-nt: Shutdown complete

    测度是上次加了参数后,向来没运营起来。。。已经非常久没用本机的mysql了。
    查了下,原本my.ini里有一句:default-storage-engine=INNODB,把暗中认可的engine设为INNODB,而自己又加了skip-innodb,怪不得启不来了。

    090613 10:15:27 [Note] C:wwwmysqlbinmysqld-nt: Shutdown complete

    mysql Non-Transactional Database Only(只支持MyISAM),nontransactional

    新兴在做WordPress,一齐先还不领悟原本WordPress用的是InnoDB数据引擎,于是在原来的数据Curry面就建了贰个数据库,一初始也没察觉问题,安装,导入sql,都没难题,当时也没多想。直到近些日子因为又要装多多个WordPress,用phpmyadmin访问数据库多或多或少,难点来了。老是一看望WordPress的数据库,就弹出荒谬提醒“Mysqld-nt.exe应用程序错误:“0x005346c4”指令引用的“0x0078四千”内部存款和储蓄器,该内部存储器不可能为读...”,然后就MySQL服务也停了,登入不了,整个数据库都访谈不了。

    澳门皇家赌场55533网址 1

    图1 设置数据库类型

    纠结了挺久,也忘了是看出什么作品触发了灵感,反正后来才清楚原本是数额引擎差别惹的祸。于是就想开重国民党的新生活运动行次设置指导,把数据库类型改成帮忙InnoDB引擎的。立刻行动,在向导里设置数据库类型(也正是图1的database usage)这里,设置成第二项,还在后面包车型地铁InnoDB Tablespace Settings里把InnoDB数据文件设贮存在D:MySQL InnoDB Datafiles目录里。可是在最终execute实行的时候,却老是在Start Service这里出标题,如下图2。

    澳门皇家赌场55533网址 2

    图2 Start service出错

    想向来到services.msc里面运维服务,也拾叁分。错误提醒内容为:“在 本地计算机 不可能起动mysql服务 错误1067:进度意外中止。

    依照互连网的一些做法,卸载了MySQL服务,也没重启就再也安装,难题还是;把劳务卸载了,重启后再重新初始化,则是运行服务成功,不过在末端的Applying Security Settings的时候有新的标题,如下图3。图2这里的一无所能提示则改为“E奥迪Q7ROEvoque 二零零零: Can't connect to MySQL server on 'localhost' (10061)", 表明MySQL照旧不曾运转,或许运行过,出错又关了。

    澳门皇家赌场55533网址 3

    图3

    附带提一下,在MySQL5里(其余版本的本身不晓得)每运转叁次设置教导,只要按了execute实践,都会在MySQL5的设置目录下自动生成多个原先的MySQL的设置文件my.ini的备份bak文件。並且将以修改的光阴命名。由此一旦设置出了难点,能够从备份文件苏醒。

    后来要么在错误日志里找到思路。错误日志即是位于 MySQL5装置目录Data 目录里的老大以你的微管理器名命名的.err文件。

    首先作者找到以下一段:

    InnoDB: Error: log file .ib_logfile0 is of different size 0 52428800 bytes

    InnoDB: than specified in the .cnf file 0 10485760 bytes!

    101001 9:47:42 [ERROR] Default storage engine (InnoDB) is not available

    101001 9:47:42 [ERROR] Aborting

    101001 9:47:42 [Note] D:MySQL5binmysqld-nt: Shutdown complete

    于是乎就到“MySQL5安装目录Data ”目录里把ib_logfile0日志文件删掉,重启MySQL服务,依旧提醒10067谬误。再去查看err文件。

    101001 18:39:29 InnoDB: Log file .ib_logfile0 did not exist: new to be created

    InnoDB: Setting log file .ib_logfile0 size to 109 MB

    InnoDB: Database physically writes the file full: wait...

    InnoDB: Progress in MB: 100

    InnoDB: Error: log file .ib_logfile1 is of different size 0 52428800 bytes

    InnoDB: than specified in the .cnf file 0 114294784 bytes!

    101001 18:39:30 [ERROR] Default storage engine (InnoDB) is not available

    101001 18:39:30 [ERROR] Aborting

    101001 18:39:30 [Note] D:MySQL5binmysqld-nt: Shutdown complete

    能够观望,ib_logfile0的标题一举成功了,但是同样的难题却出在ib_logfile1上边了。于是依样画葫芦,把ib_logfile1删了,再重启MySQL服务,却开采没用。难道是还要重启系统。果真,把前面四个ib_logfile删了,重启系统就化解了。前面的可能是因为刚开机,所以也行。事实上是急需重启系统的。那时的日志如下

    101001 19:19:24 InnoDB: Log file .ib_logfile0 did not exist: new to be created

    InnoDB: Setting log file .ib_logfile0 size to 109 MB

    InnoDB: Database physically writes the file full: wait...

    InnoDB: Progress in MB: 100

    101001 19:19:26 InnoDB: Log file .ib_logfile1 did not exist: new to be created

    InnoDB: Setting log file .ib_logfile1 size to 109 MB

    InnoDB: Database physically writes the file full: wait...

    InnoDB: Progress in MB: 100

    InnoDB: Cannot initialize created log files because

    InnoDB: data files are corrupt, or new data files were

    InnoDB: created when the database was started previous

    澳门皇家赌场55533网址,InnoDB: time but the database was not shut down

    InnoDB: normally after that.

    101001 19:19:27 [ERROR] Default storage engine (InnoDB) is not available

    101001 19:19:27 [ERROR] Aborting

    101001 19:19:27 [Note] D:MySQL5binmysqld-nt: Shutdown complete

    好了,未来只剩余最终一个主题素材了Default storage engine (InnoDB) is not available。去services.msc里面运转MySQL服务,依旧出错。然则日志却是彰显

    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:

    101001 20:45:09 [ERROR] Default storage engine (InnoDB) is not available

    101001 20:45:09 [ERROR] Aborting

    101001 20:45:09 [Note] D:MySQL5binmysqld-nt: Shutdown complete

    于是去互连网查找了须臾间,开掘提醒No valid checkpoint found.的解决办法:删除全数现存的ibdataN和ib_logfileN文件后,重启Mysql。于是照做,果然行了。

    InnoDB: The first specified data file D:MySQL InnoDB Datafilesibdata1 did not exist:

    InnoDB: a new database to be created!

    101001 21:04:24 InnoDB: Setting file D:MySQL InnoDB Datafilesibdata1 size to 10 MB

    InnoDB: Database physically writes the file full: wait...

    101001 21:04:25 InnoDB: Log file .ib_logfile0 did not exist: new to be created

    InnoDB: Setting log file .ib_logfile0 size to 109 MB

    InnoDB: Database physically writes the file full: wait...

    InnoDB: Progress in MB: 100

    101001 21:04:27 InnoDB: Log file .ib_logfile1 did not exist: new to be created

    InnoDB: Setting log file .ib_logfile1 size to 109 MB

    InnoDB: Database physically writes the file full: wait...

    InnoDB: Progress in MB: 100

    InnoDB: Doublewrite buffer not found: creating new

    InnoDB: Doublewrite buffer created

    InnoDB: Creating foreign key constraint system tables

    InnoDB: Foreign key constraint system tables created

    101001 21:04:31 InnoDB: Started; log sequence number 0 0

    101001 21:04:32 [Note] D:MySQL5binmysqld-nt: ready for connections.

    Version: '5.0.18-nt' socket: '' port: 3306 MySQL Community Edition (GPL)

    冲刺了一天,总算成功地把MySQL从MyISAM调换来InnoDB引擎了。也学会了读懂错误日志文件err文件了。不过笔者就在想了,尽管从一起首就依照上边的做,不晓得会什么啊?
    转自 DarkBlue blog

    Non-Transactional Database Only(只帮忙MyISAM),nontransactional 后来在做WordPress,一起初还不亮堂原本WordPress用的是InnoDB数据引擎,于是在原本的...

    将default-storage-engine改为MYISAM,MYSQL启动OK!
    在skip-innodb下,data目录下的ibdata1,ib_logfile0,ib_logfile1那多少个文件就无需了,就足以去除。

    090613 10:15:27 [Note] C:wwwmysqlbinmysqld-nt: Shutdown complete

    090613 10:30:12 [Note] C:wwwmysqlbinmysqld-nt: Shutdown complete

    测量检验了下,在没加skip-innodb时,删除了那多少个公文,运营时会自行创造那八个公文,日志如下:
    引用
    InnoDB: The first specified data file .ibdata1 did not exist:
    InnoDB: a new database to be created!
    090613 10:19:37 InnoDB: Setting file .ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    090613 10:19:37 InnoDB: Log file .ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file .ib_logfile0 size to 24 MB
    InnoDB: Database physically writes the file full: wait...
    090613 10:19:38 InnoDB: Log file .ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file .ib_logfile1 size to 24 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    090613 10:19:39 InnoDB: Started; log sequence number 0 0
    090613 10:19:39 [Note] C:wwwmysqlbinmysqld-nt: ready for connections.

    那三个公文就不会自动发出了。

    作者那样设置后,在linux下都没难题,明日在本身本机winXP运维MYSQL,提醒运转不起来。看下m...

    那八个文本就不会自行发出了。

    090613 10:30:17 [Note] C:wwwmysqlbinmysqld-nt: ready for connections.
    Version: '5.0.45' socket: '' port: 3306 Source distribution

    是mysql教程配置文件禁掉了这么些选项!
    关闭mysql数据库教程
    在mysql的设置目录中找到my.ini文件
    找到skip-innodb,在前边加上#号
    保存,开启mysql数据库!搞定!
    那也是开启Mysql数据库InnoDB效用的不二等秘书籍!!

    本文由68399皇家赌场发布于虚拟主机,转载请注明出处:【澳门皇家赌场55533网址】mysql InnoDB数据不可能起

    关键词: 68399皇家赌场

上一篇:mysql数据库用户和权限管理记录

下一篇:没有了