On Mon, Jul 5, 2010 at 9:06 AM, Rob Wultsch <wultsch@stripped> wrote:
> On Sun, Jul 4, 2010 at 8:35 PM, James Corteciano <james@stripped>
>> Hi All,
>> I have received error message "ERROR 1030 (HY000) at line 167: Got error 139
>> from storage engine" when importing dump database to MySQL server. The MySQL
>> server is using InnoDB. I have google it and it's something problem on
>> a row-length limit in the InnoDB table.
>> Any have idea how to fix this?
> I can not recall having seen that error before. I did a slight amount
> of googling and it sounds like it might be a innodb tuning issue.
> Please post:
> 1. Any relevant entries in your error log file.
> 2. Your my.cnf.
> 3. You servers specs and whether the server also runs other daemons.
> Rob Wultsch
It would also be helpful for you to run the import with the verbose
flag. Then we would have a better understanding of exactly what
statement was causing the error.