Hi Eduard, Eduard M [mailto:[EMAIL PROTECTED] wrote:
> I try to export/import a database schema with all tables and > data using loadercli, with the following command: > TABLELOAD USER > CATALOG INSTREAM 'cativen-catalog.dat' > DATA INSTREAM 'cativen-data.dat' > > and every time import fails with the following error: > Internal error [vls28_TLoad.cpp, 1453, -25342]; contact > technical support > it would be interesting, which version of kernel and Loader you use. Additionally it would be extremely helpful if you'd send the loader.prt. This file normally contains more information on errors happened. > I've found one reply to a similar question posted before, > which suggests to set COLUMNCOMPRESSION parameter to NO on > both db instances. However that did not help me. > Any other suggestions? > COLUMNCOMPRESSION could be a problem if you migrate from a 7.5 db to 7.6. The loader logfile loader.prt would contain specific errors like "Definitions of source and target table <table name> do not match; length type of <column name>: target = variable length, source = fix length." > Another thing that I've noticed, that if say a source schema > contains a function that does not compile, import is aborted > upon load of that function. Is there a way to ignore that? > Basically, I need to be able to import/export schemas the > same way I can backup/restore a database. > You can't. The Loader is definitely not a tool to backup and restore. It is thought to export and import (and transform) definitions and data. But you can customize the Loader to ignore errors by either setting MAXERRORCOUNT (in this case the Loader ignores as many errors as specified when executing a single command) or the -E option when running batch scripts. The -E option would cause the Loader to ignore as many erroroneous commands as specified by this option. Regards, Steffen -- Steffen Schildberg MaxDB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
