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