MySQL Forums
Forum List  »  Knowledge Base

Convert 4.1 MyISAM table to 5.0 InnoDB
Posted by: Jay Kusch
Date: May 09, 2008 07:17AM

I have a 4.1 MyISAM table that contains 90 LongText columns.

Trying to convert the table to InnoDB but receiving the error of:

"MySQL Error Number 1030 - Got error 139 from storage engine"

Is this because the 90 LongText columns exceeds the 8000 byte limit on an InnoDB table and if so ... how can I overcome this issue.

Thanks for any and all help!

Options: ReplyQuote


Subject
Views
Written By
Posted
Convert 4.1 MyISAM table to 5.0 InnoDB
3282
May 09, 2008 07:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.