unknown table engine innodb

xiaoxiao2021-02-28  76

服务器不正常关机,重启以后mysql数据库出现unknown table engine innodb,不能访问表和建表等

show engines;

innodb状态是空的

解决把my.cnf配置文件重新修改一下或换成新的可以使用的my.cnf(具体配置看自己的配置)

[mysqld] datadir=/app/mysql/data socket =/app/mysql/data/mysql.sock lower_case_table_names=1 character-set-server=utf8 collation-server=utf8_general_ci [client] default-character-set=utf8 socket =/app/mysql/data/mysql.sock  [mysql.server] user=mysql basedir=/app/mysql default-character-set=utf8 [mysqld_safe] err-log=/app/mysql/errlog/mysqld.log

转载请注明原文地址: https://www.6miu.com/read-53324.html

最新回复(0)