maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #06320
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