mariadb-server 错误表在引擎状态中不存在:操作失败

mariadb-server 错误表在引擎状态中不存在:操作失败

我尝试将数据库模板导入服务器,但在此过程中服务器损坏了。出现了各种错误。无论如何,最关键的一步是让它恢复工作。

...
Error    : Table 'mysql.innodb_index_stats' doesn't exist in engine
status   : Operation failed
mysql.innodb_table_stats
Error    : Table 'mysql.innodb_table_stats' doesn't exist in engine
status   : Operation failed
...
...
Error    : Table 'mysql.transaction_registry' doesn't exist in engine
status   : Operation failed
...
...
Phase 4/7: Running 'mysql_fix_privilege_tables'
ERROR 1813 (HY000) at line 153: Tablespace for table '`mysql`.`gtid_slave_pos`' exists. Please DISCARD the tablespace before IMPORT
ERROR 1932 (42S02) at line 639: Table 'mysql.innodb_index_stats' doesn't exist in engine
ERROR 1243 (HY000) at line 640: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1932 (42S02) at line 642: Table 'mysql.innodb_table_stats' doesn't exist in engine
ERROR 1243 (HY000) at line 643: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1932 (42S02) at line 647: Table 'mysql.innodb_index_stats' doesn't exist in engine
ERROR 1932 (42S02) at line 651: Table 'mysql.innodb_table_stats' doesn't exist in engine
ERROR 1932 (42S02) at line 654: Table 'mysql.innodb_table_stats' doesn't exist in engine

环境:10.3.27-MariaDB 删除不起作用。我正在考虑清除选项,但我担心会删除一些关键文件。

相关内容