XAMPP开启mysql失败
今天导入一个sql文件,结果脑抽选了遇到错误继续,然后mysql就崩了,启动不了,查看错误日志如下图
求大神解救
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
今天导入一个sql文件,结果脑抽选了遇到错误继续,然后mysql就崩了,启动不了,查看错误日志如下图
求大神解救
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
接受
或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
发布评论
评论(1)
2017-08-07 18:00:25 2998 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2017-08-07 18:00:25 10648 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-08-07 18:00:25 10648 [Note] InnoDB: The InnoDB memory heap is disabled
2017-08-07 18:00:25 10648 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-08-07 18:00:25 10648 [Note] InnoDB: Memory barrier is not used
2017-08-07 18:00:25 10648 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-08-07 18:00:25 10648 [Note] InnoDB: Using generic crc32 instructions
2017-08-07 18:00:25 10648 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-08-07 18:00:25 10648 [Note] InnoDB: Completed initialization of buffer pool
2017-08-07 18:00:25 10648 [Note] InnoDB: Restoring page 0 of tablespace 0
2017-08-07 18:00:25 10648 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0
2017-08-07 18:00:25 10648 [ERROR] InnoDB: space header page consists of zero bytes in data file D:XAMPPmysqldataibdata1
2017-08-07 18:00:25 10648 [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!
2017-08-07 18:00:25 10648 [ERROR] Plugin 'InnoDB' init function returned error.
2017-08-07 18:00:25 10648 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-08-07 18:00:25 10648 [Note] Plugin 'FEEDBACK' is disabled.
2017-08-07 18:00:25 10648 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2017-08-07 18:00:25 10648 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-08-07 18:00:25 10648 [ERROR] Aborting
图片貌似太小了,看这个,求救