|
Date: Tuesday, October
23, 2001 09:49:30 AM
Subject: Unload / Input
problems
A database suffered some kind of damage resulting in a
table with a
name of 3bd57d9f (not one of mine) that was, in fact,
a duplicate of another table in the database. I've seen this done when an
irregular exit occurs. The "original" version of this table also
lost the table reference for an FK (no table in that column under "keys"
in RBD. Changes did not work (drop FK, delete a previously-deleted
rule (!)). Since I was unable to change the structure I decided on the
unload.
As I've done before (although not with this database) I
unloaded the
structure then the data. However, upon input I'm getting
errors that I can
t figure out the way around:
For
example:
-ERROR- Default length must be no longer than 60 chars
(2791)
The structure from the unload is:
CREATE TABLE `StMove`
+
(`StMvID` INTEGER NOT NULL , +
`SID` INTEGER NOT NULL ,
+
`STitle` INTEGER , +
`Prog` INTEGER NOT NULL , +
`Dstart` DATE
, +
`DEnd` DATE , +
`DLWk` DATE , +
`MvType` INTEGER ,
+
`MFTE` INTEGER )
I don't see anything that could be > 60
chars.
Another:
-ERROR- Constraints must be separated by commas
(2795)
CREATE TABLE `DiMarry` +
(`Val` INTEGER NOT NULL ,
+
`TVal` TEXT (6) , +
`TDesc` TEXT (45) , +
`Obs` TEXT (1)
DEFAULT 'N' )
Although the contraints load further down in the
file.
and finally...
-ERROR- Illegal table name - DiRefout
(2037)
I've had other errors, but those mostly relate to load order
(cut & paste
fixes that), but these are the stumpers.
tia
for any insight.
Dave
[EMAIL PROTECTED]g |
