'ERROR: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY/INPLACE
I have used mysqldump to create a table that is 12GB from MySQL 5.7 to MySQL 8.0.29. I want to add a column using ALTER TABLE documents ADD COLUMN meta_data json NULL, algorithm=instant; in the new table created in 8.0.29. When I run this I keep getting the error ERROR: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY/INPLACE.
When searching Google I can only find information about a bug that should have been fixed in 8.0.14 as can be seen here .
I do not have any fulltext index on my table and trying to add the column to the end of the list.
Anyone know why this is not working?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|