我尝试将数据库模板导入服务器,但在此过程中服务器损坏了。出现了各种错误。无论如何,最关键的一步是让它恢复工作。
...
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 删除不起作用。我正在考虑清除选项,但我担心会删除一些关键文件。