服务器 Gind.cn
  1. 服务器 Gind.cn
  3. 计算机重新启动后无法启动MySQL 5.6服务器
Intereting Posts
是否有Windows 7兼容性matrix？ Ubuntu的12.04 – svn重新定位和系统重新启动 非常不规则的磁盘写入性能和重复的SATA超时 为什么使用Dovecot和Postfix / Sendmail？ 不正确的ASP.NET会话数据间歇返回 DigitalOcean DNS可以将新的cnamelogging与现有的通配符cnamelogging冲突 多个站点一个物理的windows服务器 Debian调优增加读/写缓冲区 如何在sedscript中使用variables Elasticsearch删除具有特殊字符的索引 必须有本地用户authenticationSamba到AD？ logging客户端连接错误/closures连接与Apache Postfix邮件服务器拒绝从wordpress站点发送邮件 连接到MySQL的PHP​​内存不足 无法通过Tomcat或外部通过JDBC连接器连接到MySQL

计算机重新启动后无法启动MySQL 5.6服务器

昨天我安装了MySQL 5.6，服务器运行没有任何问题。

正在Windows 7上运行

但今天我无法启动服务器！

错误日志 

2013-04-29 09:59:07 4368 [Note] Plugin 'FEDERATED' is disabled. 2013-04-29 09:59:07 4368 [Note] InnoDB: The InnoDB memory heap is disabled 2013-04-29 09:59:07 4368 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2013-04-29 09:59:07 4368 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-04-29 09:59:07 4368 [Note] InnoDB: Not using CPU crc32 instructions 2013-04-29 09:59:07 4368 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2013-04-29 09:59:07 4368 [Note] InnoDB: Completed initialization of buffer pool 2013-04-29 09:59:07 4368 [ERROR] InnoDB: read can't be opened in .\ibdata1 mode 2013-04-29 09:59:07 4368 [ERROR] InnoDB: The system tablespace must be writable! 2013-04-29 09:59:07 4368 [ERROR] Plugin 'InnoDB' init function returned error. 2013-04-29 09:59:07 4368 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2013-04-29 09:59:07 4368 [ERROR] Unknown/unsupported storage engine: InnoDB 2013-04-29 09:59:07 4368 [ERROR] Aborting 2013-04-29 09:59:07 4368 [Note] Binlog end 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'partition' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_METRICS' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_CMP' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'INNODB_TRX' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'BLACKHOLE' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'ARCHIVE' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'MRG_MYISAM' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'MyISAM' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'MEMORY' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'CSV' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'sha256_password' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'mysql_old_password' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'mysql_native_password' 2013-04-29 09:59:07 4368 [Note] Shutting down plugin 'binlog' 2013-04-29 09:59:07 4368 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Shutdown complete

当MySQL在my.ini的innodb_data_home_dir选项指定的path中找不到ibdata1文件时，MySQL将执行此操作。 你应该检查path。 确保文件在那里，可以被MySQL使用的凭证访问。

如果这个文件实际上没有了，因为它代表了innodb表空间，我不确定这个场景是否可以恢复，除非通过删除所有东西并从备份恢复。