bhuvan83 0 Light Poster

i m exporting my table from one system to another.
when i do shell# mysql databasename<file.txt
i get the error given above.
the table i create is ->

CREATE TABLE entrytab (
uname varchar(10) default NULL,
enterDate date default NULL,
status varchar(10) default NULL,
productName varchar(15) default NULL,
featureName varchar(20) default NULL,
activityName varchar(20) default NULL,
duration decimal(3,1) default NULL,
KEY uname (uname),
CONSTRAINT `entrytab_ibfk_1` FOREIGN KEY (`uname`) REFERENCES `usertab` (`uname`)
) TYPE=InnoDB;

can any1 plz tell me the problem n soln to that
thanks in advance

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.