MySQL not launching on XAMPP
来源:互联网 发布:更改手机图标软件 编辑:程序博客网 时间:2024/06/04 17:46
今天打开xampp的mysql时报出了以下错误
2017-07-26 07:35:04 11048 [Note] Plugin 'FEDERATED' is disabled.2017-07-26 07:35:04 2874 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-07-26 07:35:04 11048 [Note] InnoDB: The InnoDB memory heap is disabled2017-07-26 07:35:04 11048 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2017-07-26 07:35:04 11048 [Note] InnoDB: Compressed tables use zlib 1.2.32017-07-26 07:35:04 11048 [Note] InnoDB: Not using CPU crc32 instructions2017-07-26 07:35:04 11048 [Note] InnoDB: Initializing buffer pool, size = 16.0M2017-07-26 07:35:04 11048 [Note] InnoDB: Completed initialization of buffer pool2017-07-26 07:35:04 11048 [Note] InnoDB: Highest supported file format is Barracuda.2017-07-26 07:35:04 11048 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 1735445 in the ib_logfiles!2017-07-26 07:35:04 11048 [Note] InnoDB: Database was not shutdown normally!2017-07-26 07:35:04 11048 [Note] InnoDB: Starting crash recovery.2017-07-26 07:35:04 11048 [Note] InnoDB: Reading tablespace information from the .ibd files...2017-07-26 07:35:04 11048 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace how2java/category_ uses space ID: 1 at filepath: .\how2java\category_.ibd. Cannot open tablespace mysql/innodb_table_stats which uses space ID: 1 at filepath: .\mysql\innodb_table_stats.ibdInnoDB: Error: could not open single-table tablespace file .\mysql\innodb_table_stats.ibdInnoDB: We do not continue the crash recovery, because the table may becomeInnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.InnoDB: To fix the problem and start mysqld:InnoDB: 1) If there is a permission problem in the file and mysqld cannotInnoDB: open the file, you should modify the permissions.InnoDB: 2) If the table is not needed, or you can restore it from a backup,InnoDB: then you can remove the .ibd file, and InnoDB will do a normalInnoDB: crash recovery and ignore that table.InnoDB: 3) If the file system or the disk is broken, and you cannot removeInnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnfInnoDB: and force InnoDB to continue crash recovery here.
其中有一行出现了error,然后下面具体解释了解决方案是什么,也就是这一行:
InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_table_stats.ibd
这个错误可以按照解决方案来做,然后
https://stackoverflow.com/questions/19211817/mysql-not-launching-on-xampp
也有人翻译了一下说具体怎么做
但是都不好用,在最后一条回复的地方发现是好用的,也就是
exit Xampp server go to your C:\xampp\mysql\data directory delete the ibdata1 file restart xampp server It should work
即退出xampp,然后删除D:\xampp\mysql\data\ibdata1文件,重启xampp就好了
阅读全文
0 0
- MySQL not launching on XAMPP
- Launching Spark on YARN
- Launching Spark on YARN
- launching not activity
- Launching app : The APK file xxxx.apk does not exist on disk Error while Installing APK
- XAMPP运行MySQL entire log window on the forums解决方案
- Virtual Machine not launching Gazebo
- Intl Extension missing on Xampp
- xampp's mysql
- XAMPP和MYSQL使用
- XAMPP无法启动MySql
- XAMPP无法启动MySql
- somthing about xampp mysql
- somthing about xampp mysql
- 修改xampp-mysql密码
- XAMPP mysql远程连接
- Xampp中mysql错误
- XAMPP启动mysql异常
- 关于HttpSession前台无值后台有值的解决方法
- config.properties的配置
- Session和Cookie
- 深入理解 Android 之 View 的绘制流程(五)_invalidate,postInvalidate和requestLayout
- jquery的鼠标访问事件
- MySQL not launching on XAMPP
- java设计模式总共有23种设计模式
- 记Dorado7学习(1)
- 百度编辑器ueditor上传图片顺序乱掉修改方法
- KVM地址翻译流程及EPT页表的建立过程
- JAVA中内部类的继承和覆盖问题
- 编写可维护的javascript(二):注释
- codeforces 719A Vitya in the Countryside
- HDU