RSS

error 1005 at line 46: Can't create table '.\time\entrytab.frm' (errno :150)

Please support our MySQL advertiser: Programming Forums

error 1005 at line 46: Can't create table '.\time\entrytab.frm' (errno :150)

•

Join Date: Mar 2007

Location: India

Posts: 28

Reputation: bhuvan83 is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

bhuvan83

Offline

Light Poster

error 1005 at line 46: Can't create table '.\time\entrytab.frm' (errno :150)

Mar 21st, 2007

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

Bhuvan Aggarwal
There is no word impossible.
its i m possible

DaniWeb Home > Forums > Web Development > Databases > MySQL > error 1005 at line 46:...

error 1005 at line 46: Can't create table '.\time\entrytab.frm' (errno :150)

error 1005 at line 46: Can't create table '.\time\entrytab.frm' (errno :150)

error 1005 at line 46: Can't create table '.\time\entrytab.frm' (errno :150)