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 .
On Mon, Jul 5, 2010 at 9:36 PM, 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
> > from storage engine" when importing dump database to MySQL server. The
> > 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
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
Mobile : 91-9987681929
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat