← Back to team overview

maria-discuss team mailing list archive

mysql_upgrade and error 'Table rebuild required. Please do "ALTER TABLE `table1` FORCE" or dump/reload to fix it!'

 

Hello list,

After upgrading a database from 10.5 to 10.6 I get messages like below
for a couple of the tables when I run mysql_upgrade:

error    : Table rebuild required. Please do "ALTER TABLE `table1`
FORCE" or dump/reload to fix it!

But at the end of the output it says:

Repairing tables
`database1`.`table1`             FIXED
`database1`.`table2`             FIXED

.... and so on - it lists all the tables that it previously said I
needed to rebuild as "fixed".

So, does that mean I don't need to do anything, or should I still run
the ALTER TABLE statements?

It seems I can SELECT + DELETE from and INSERT into the tables without
getting any errors, so presumably I don't have to worry?

Regards,
Karl