If the SQL mode or primary keys requirement was changed to something more strict since the tables were originally created, rebuilding the tables will fail.
Rebuilding essentially behaves as if the CREATE TABLE statement was re-executed.
To fix that, lower the requirements while rebuilding the tables.
About this change: What it does, why it matters
If the SQL mode or primary keys requirement was changed to something more strict since the tables were originally created, rebuilding the tables will fail.
Rebuilding essentially behaves as if the CREATE TABLE statement was re-executed.
To fix that, lower the requirements while rebuilding the tables.