我修改了my.cnf,添加了tmpdir=/mnt/sdb1/tmp
然后打开数据库就提示Unknown table engine ‘InnoDb’
然后用show engines; Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+就这几项,把my.cnf的删掉的话数据库就又可以用了这是什么原因- - -
然后打开数据库就提示Unknown table engine ‘InnoDb’
然后用show engines; Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+就这几项,把my.cnf的删掉的话数据库就又可以用了这是什么原因- - -
解决方案 »
- MySQL 怎么同步(或者共用)用户信息?
- mysql打包安装问题
- mysql函数中传入表名参数的问题!
- 向各位大侠求教一个MySQL删除特定行的问题
- 如何用mysql 的c api 对jpg文件的读写?
- select 可以查询到相应行,可是却不能delete
- MySQL设置密码的问题
- 关于C++程序中与Mysql之间的连接问题
- 怎么在PB中的configure odbc中没有mysql的选项,但在控制面板的odbc中已经有?????
- MySQL创建一个数据库,关掉之后,再打开那个数据库就消失了,在创建还是这样
- 跨表更新的值马上读取的bug
- 数据库查找某个时间字段距离现在超过15天的数据的语句
然后我chmod 777了。还是这样
结帖率:0%
当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://bbs.csdn.net/help#post_dispose