On Mon, Jul 5, 2010 at 9:06 AM, Rob Wultsch <wult...@gmail.com> wrote: > On Sun, Jul 4, 2010 at 8:35 PM, James Corteciano <ja...@linux-source.org> > wrote: >> 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 >> exceeding >> a row-length limit in the InnoDB table. >> >> Any have idea how to fix this? >> >> Thanks. >> >> Regards, >> James >> > > 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 > wult...@gmail.com >
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. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org