我修改了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的刪掉的話資料庫就又可以用了。。。這是什么原因- - -
uj5u.com熱心網友回復：
現在看了下mysql.log 他寫can,t write file /mnt/sdb1/tmp然后我chmod 777了。還是這樣
uj5u.com熱心網友回復：
chown mysql /mnt/sdb1/tmpuj5u.com熱心網友回復：
如果是ubuntu 看看/etc/apparmor.d/usr.sbin.mysqld這個目錄uj5u.com熱心網友回復：
結帖率：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.html
8、如何給分和結貼？
http://bbs.csdn.net/help#post_dispose
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/109488.html
標籤：MySQL
上一篇：mysql中匯出文本問題