RedAlan. Los Blogs

Thursday, June 17, 2021

MySQL. Error 1031

If you have a MYSQL database with version 5.3 or earlier, and you try to do a transfer to a higher engine, you may find that some table gives you error 1031, and a description similar to "Table storage engine for 'table' doesn't have this option", it is very possible that, when that table was created, it was created with a ROW_FORMAT = FIXED.

And if you are using InnoDB, you should know that it only supports REDUNDANT, COMPACT, DYNAMIC and COMPRESSED formats.

Change the row_format of your table and.... go!

No comments:

Post a Comment