关闭

查询innodb表时报错:ERROR 1286 (42000): Unknown table engine 'InnoDB'

标签: databasemysql
3134人阅读 评论(0) 收藏 举报
分类:
查询innodb表时报错:ERROR 1286 (42000): Unknown table engine 'InnoDB'

mysql> select * from po_t limit 1;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: gsp

ERROR 1286 (42000): Unknown table engine 'InnoDB'
mysql>
mysql>

解决办法:
1.停止mysql
2.将innodb_data_home_dir对应目录下的ib_logfile* mv到/tmp或其他目录中
3.启动Mysql

再次查询,发现可以正常查询了:
mysql> select * from po_t limit 1;
+----------------+--------------------+--------+---------------------+----------------+------------------+---------------+---------------------+-------------+--------------+------------------+-----------+---------------------+---------------------+----------------+----------------------+-------------+---------+---------+
| PICKINGLIST_ID | RECEIVEMATERIAL_ID | STATUS | OUTTIME             | OUTWAREHOUSEER | PICKINGLIST_CODE | CREATEUSER_ID | CREATEDATE          | COMPANYCODE | WAREHOUSE_ID | PICKINGLIST_TYPE | IS_UPLOAD | ORDER_CREATED_DATE  | ORDER_RECEIVED_DATE | THROWORDERCODE | THROWRESERVATIONCODE | COMMITER_ID | EXETIME | VERSION |
+----------------+--------------------+--------+---------------------+----------------+------------------+---------------+---------------------+-------------+--------------+------------------+-----------+---------------------+---------------------+----------------+----------------------+-------------+---------+---------+
|              1 |                  1 | 4      | 2009-07-16 15:45:02 | NULL           | 2009071600001    |           441 | 2009-07-16 15:12:53 | 1010        |            1 |             NULL |         0 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | NULL           | NULL                 |        NULL | NULL    |       0 |
+----------------+--------------------+--------+---------------------+----------------+------------------+---------------+---------------------+-------------+--------------+------------------+-----------+---------------------+---------------------+----------------+----------------------+-------------+---------+---------+
1 row in set (0.00 sec)

mysql>

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:152503次
    • 积分:2680
    • 等级:
    • 排名:第14119名
    • 原创:111篇
    • 转载:14篇
    • 译文:1篇
    • 评论:16条
    文章分类
    最新评论