mysql 1286_mysql – 1286 – 未知存储引擎’InnoDB’

我试图使用圆形立方体,它最近刚刚破产.我不知道这是否是由于最近发生的

MySQL更新,但在phpMyAdmin中,如果我尝试查看表格,我会收到以下错误：

1286 - Unknown storage engine 'InnoDB'

和

mysql> 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 | MyISAM storage engine | NO | NO | NO |

| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |

| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |

| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |

| ARCHIVE | YES | Archive storage engine | NO | NO | NO |

| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

8 rows in set (0.00 sec)

和

[mysqld]

default-storage-engine=MyISAM

local-infile=0

symbolic-links=0

skip-networking

max_connections = 500

max_user_connections = 20

key_buffer = 512M

myisam_sort_buffer_size = 64M

join_buffer_size = 64M

read_buffer_size = 12M

sort_buffer_size = 12M

read_rnd_buffer_size = 12M

table_cache = 2048

thread_cache_size = 16K

wait_timeout = 30

connect_timeout = 15

tmp_table_size = 64M

max_heap_table_size = 64M

max_allowed_packet = 64M

max_connect_errors = 10

query_cache_limit = 1M

query_cache_size = 64M

query_cache_type = 1

low_priority_updates=1

concurrent_insert=ALWAYS

log-error=/var/log/mysql/error.log

tmpdir=/home/mysqltmp

myisam_repair_threads=4

[mysqld_safe]

open_files_limit = 8192

log-error=/var/log/mysql/error.log

[mysqldump]

quick

max_allowed_packet = 512M

[myisamchk]

key_buffer = 64M

sort_buffer = 64M

read_buffer = 16M

write_buffer = 16M

关于如何修复的想法？过去工作得很好.