OffOn
    Register
    HomeMySQL

    MySQL Error MY-010884 – ER_INNODB_PK_ONLY_IN_MYSQL

    admin November 14, 2024 No Comments

    MySQL Error Message

    Table %s has no primary key in InnoDB data dictionary,
    but has one in MySQL! If you created the table with a MySQL
    version < 3.23.54 and did not define a primary key, but defined
    a unique key with all non-NULL columns, then MySQL internally
    treats that key as the primary key. You can fix this error by dump
    + DROP + CREATE + reimport of the table.

    Reason for the Error

    ER_INNODB_PK_ONLY_IN_MYSQL was
    added in 8.0.2.

    Tag:

    Share:

    Leave A Reply

    Your email address will not be published. Required fields are marked *

    You May Also Like

    See more
    code coder coding computer

    MySQL Error MY-010296 – ER_X509_CANT_READ_CA_KEY

    MySQL Error Message Could not read CA key file: %s Reason for the Error ER_X509_CANT_READ_CA_KEY was added in 8.0.2.
    Read more
    code coder coding computer

    MySQL Error MY-010588 – ER_RPL_SLAVE_READ_INVALID_EVENT_FROM_MASTER

    MySQL Error Message Read invalid event from master: ‘%s’, master could be corrupt but a more likely cause of this...
    Read more
    code coder coding computer

    MySQL Error MY-012140 – ER_IB_MSG_315

    MySQL Error Message %s Reason for the Error ER_IB_MSG_315 was added in 8.0.11.
    Read more