Hi! >I received a table handler error 139 on several occasions while trying >to convert a table to type InnoDB (alter table data type=InnoDB). I >ran a check table and optimize table on it, and converted it from >MyISAM to BDB successfully. Today, when I tried it again to get the >exact error message for this E-mail, it seems to be running fine (48749 >rows don't convert instantly ;-). Any ideas as to what this could be?
Error 139 means too big row. Did you use a recent version of MySQL? InnoDB BLOB support came some time in summer. >-- >Michael T. Babcock >CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) >http://www.fibrespeed.net/~mbabcock/ Regards, Heikki Innobase Oy --- See http://www.innodb.com for the latest news about InnoDB Order commercial MySQL/InnoDB support at https://order.mysql.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
