I think this is related to foreign key constraint data types don't match up... so verify your CREATE TABLE structure or post the CREATE TABLE statement for your table.
Or there is chance of data type size and the value you are inserting.. such type of problem occurs if the data import ie source and restore ie target are of different versions . Thanks, On Mon, Jul 5, 2010 at 9:36 PM, 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 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com > > -- Best Regards, Prabhat Kumar MySQL DBA Datavail-India Mumbai Mobile : 91-9987681929 www.datavail.com My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
