[Maria-discuss] mysql_upgrade and error 'Table rebuild required. Please do "ALTER TABLE `table1` FORCE" or dump/reload to fix it!'
18 Aug
2022
18 Aug
'22
7:29 p.m.
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
641
Age (days ago)
641
Last active (days ago)
0 comments
1 participants
participants (1)
-
Karl Levik