Please support our MySQL advertiser: Programming Forums
Views: 2262 | Replies: 0
•
•
Join Date: Mar 2007
Location: India
Posts: 28
Reputation: 
Rep Power: 2
Solved Threads: 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
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
Bhuvan Aggarwal
There is no word impossible.
its i m possible
There is no word impossible.
its i m possible
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Threaded Mode