☰

MySQL 不会启用 InnoDB

tag-icon • tag-icon linux mysql
MySQL 不会启用 InnoDB

我正在运行 MySQL 5.0.8

最近（昨天），我的服务器主机迁移了我的服务器，但在此过程中我的 MySQL 不知为何出现了故障。

经过一番搜寻，我相信问题在于 InnoDB 现在已被 MySQL 禁用，而且我无法重新启用它。

非常感谢任何帮助或指导。

谢谢

我的my.cnf文件如下......

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
innodb_buffer_pool_size=64M

# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:1186"

[mysqld_safe]
log-error=/var/log/mysqld.log
log-bin=/var/lib/mysql/mysqld-bin
log-slow-queries=/var/log/mysqld-slow-queries.log
pid-file=/var/run/mysqld/mysqld.pid

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"

答案1

发出以下命令， show engines并检查您是否能够INNODB在该列表中找到。如果可以，请执行以下命令，然后弹出数据库

SET default_storage_engine='INNODB'

相关内容