I'm trying to load a table dump exported with fastexport, but i get the following error:
The length of: PREFIX in row: 1 was greater than defined.
Defined: 3, Received: 3072
Here are my fastexport and fastload scripts:
.EXPORT OUTFILE "fexp.data" FORMAT FASTLOAD;
SELECT * from dbase.tablename;
and the fastload script:
DROP TABLE dbase.Error_1;
DROP TABLE dbase.Error_2;
BEGIN LOADING dbase.tablename ERRORFILES dbase.Error_1, dbase.Error_2;
INSERT INTO dbase.tname.*;
Any idea, what could be the problem?
FastExport defaults to MODE INDICATOR to deal with NULLs, but FastLoad doesn't.
So either modify
the FExp (if there are no NULLs):
.EXPORT OUTFILE "fexp.data" FORMAT FASTLOAD MODE RECORD;
or the FastLoad (if there are NULLs):
LOADING dbase.tablename ERRORFILES dbase.Error_1, dbase.Error_2 INDICATORS;