MySQL Error number: MY-010080; Symbol: ER_INNODB_MANDATORY; SQLSTATE: HY000 报错 故障修复 远程处理

文档解释

Error number: MY-010080; Symbol: ER_INNODB_MANDATORY; SQLSTATE: HY000

Message: The use of InnoDB is mandatory since MySQL 5.7. The former options like ‘–innodb=0/1/OFF/ON’ or ‘–skip-innodb’ are ignored.

Error Number: MY-010080; Symbol: ER_INNODB_MANDATORY; SQLSTATE: HY000

Error Description:

This error is triggered when a mandatory value within the InnoDB engine is missing or is not set correctly. It usually occurs when a CREATE TABLE or ALTER TABLE statement is issued on a table with an existing InnoDB data dictionary.

Common Cases:

Common cases for this type of error include when a CREATE TABLE or ALTER TABLE statement is issued on a table with an existing InnoDB data dictionary, and values such as the table space name, the file format type, or the row format are not correctly specified.

Resolution:

The resolution for this error is to first use the SHOW ENGINE INNODB STATUS command to check the current setting and verify that the mandatory value is correctly specified. Once verified, the CREATE TABLE or ALTER TABLE statement needs to be re-run, this time specifying the mandatory value correctly. It may also help to rebuild the InnoDB tablespace if that is the source of the issue.