
我嘗試將資料庫模板匯入伺服器,但在此過程中伺服器已損壞。各種錯誤都會出現。無論如何,最關鍵的一步是讓它恢復工作。
...
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 刪除不起作用。我正在考慮清除選項,但我擔心刪除一些重要文件。