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.

香港美国云服务器首选树叶云，2H2G首月10元开通。
树叶云（shuyeidc.com）提供简单好用，价格厚道的香港/美国云服务器和独立服务器。IDC+ISP+ICP资质。ARIN和APNIC会员。成熟技术团队15年行业经验。