Re: Strange problem when loading a table -- What did I do wrong?

[Brian Gray]

CREATE TABLE `students` (
`STUDID` varchar(9) NOT NULL default '',
`LNAME` varchar(30) NOT NULL default '',
`FNAME` varchar(30) NOT NULL default '',
`LEARNID` varchar(15) default NULL,
`COMMENT` text,
PRIMARY KEY (`STUDID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

I think this is what you meant by a dumpfile,
It is the result of SHOW CREATE TABLE STUDENTS;

Thanks
Brian