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

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 403,494 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,262 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 2071 | Replies: 0

•

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