MYSQL启动报1067错误 MySQL服务无法启动 或者Can't create/write to file#sql6e80_1905f7_3.MYI'
来源:互联网 发布:美工设计岗位要求 编辑:程序博客网 时间:2024/06/05 02:20
MySql数据库Plugin 'FEDERATED' is disabled.错误解决方法
Log:
121012 11:35:03 Plugin 'FEDERATED' is disabled.
121012 11:35:03 InnoDB: Error: unable to create temporary file; errno: 2
121012 11:35:03 [ERROR] Plugin 'InnoDB' init function returned error.
121012 11:35:03 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
121012 11:35:03 [ERROR] Unknown/unsupported table type: INNODB
121012 11:35:03 [ERROR] Aborting
解决方案:
一、
1、在MY.INI文件中的 [mysqld] 中增加一行tmpdir="D:/MySQL/data/"修改后,还是启动不了或者能启动但关机后又出现同样问题,接着我做了第二步,重启正常。
2、删除DATA目录下除数据库文件夹外的其他文件,重启mysql,问题解决。(删除MySQL目录下的ib_logfile0和ib_logfile1两个文件)
二、mysql在查询表结构(比如desc abc)ERROR 1 (HY000): Can'tcreate/writetofile 'E:\mysql-5.2.3\data\-install\#sql_ 5c_0.MYI' (Errcode:2)
或者Can't create/write to file#sql6e80_1905f7_3.MYI'
java.sql.SQLException: Can't create/write to file'C:\DOCUME~1\138113~3\LOCALS~1\Temp\#sql6e80_1905f7_3.MYI'
在my.ini中添加:
[mysqld]
#指定临时文件目录
tmpdir="E:/Program Files/MySQL/MySQL Server 5.1/Temp/"
- MYSQL启动报1067错误 MySQL服务无法启动 或者Can't create/write to file#sql6e80_1905f7_3.MYI'
- mysql启动报can't create/write to file 'var/run/mysqld/mysqld.pid 错误解决办法
- MySQL 诡异报错Can't create/write to file '/tmp/#sql_89b_0.MYI' (Errcode: 177 - File exists)
- mysql 启动报错 /usr/local/mysql//libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid'
- mysql> desc tablename; ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_909_0.MYI'
- mysql启动时提示 can't create/write to file 'D:\mysql\data\prn.pid'
- mysql 出现 Can't create/write to file 的错误
- Mysql 出错,Can't create/write to file C:\WINDOWS\TEMP\#sql_1588_0.MYI(Errcode:13)的解决办法
- mysql无法启动,报错 Can't start server: can't create PID file: No space left on device
- 读取Mysql数据表的错误 Can,create/write to file 'E:/temp/TEMP/#sql_9c4_0.MYI' Errcode:2
- MySQL Can't create/write to file 问题的解决
- mysql 备份Can't create/write to file
- MySQL Can't create/write to file 问题的解决
- ubuntu mysql 数据库 Can't create/write to file
- mysql into outfile ERROR : Can't create/write to file
- Mysql ERROR 1 (HY000): Can't create/write to file
- mysql Can't create/write to file 'C:\WINDOWS\...
- 解决MYSQL出现Can't create/write to file....
- Java____小数位、百分号相关
- eclipse中读取nutch爬取的数据内容
- 摄氏温度转化为相应的华氏温度
- 就业窍门:1.想好自己打算将来干什么
- xFire调用wsdl webservice超时时间设置
- MYSQL启动报1067错误 MySQL服务无法启动 或者Can't create/write to file#sql6e80_1905f7_3.MYI'
- [blabla]a quick code about linear regression using gradient descent
- Eclipse开发环境搭建
- PL/SQL database character set(AL32UTF8) and Client character set(ZHS16GBK) are different
- 黑马程序员——异常处理全过程:不怕一万,就怕万一
- 预读、物理读、逻辑读
- 【Jenkins系列之三】在Windows上安装Jenkins master & slave
- 最长公共子序列(LCS)
- HDU-5455 Fang Fang(2015沈阳网赛,带坑点水题)