Hi Thomas,
Thomas Stegbauer [mailto:[EMAIL PROTECTED] wrote:
does there exist a list, what the eror's mean?
Yes, the message list of the DB. There should be listed the Loader messages. You could use http://www.mysql.com/documentation/maxdb/default.htm and then navigate the following path: Basic Information -> Messages -> From -25000 to -25999
[snipped correct table def and some data]
if i do a:
loadercli -d acct -u user,pw
dataload table accounting.cisco3640br_200310 infile ID 1 SOURCE 2 DESTINATION 3 PACKETS 4 BYTES 5 TIMSTAMP 6 infile '/tmp/tmp2/cisco3640br_200310.csv' separator ';'
i get:
ERR -25281 Syntax error at position 56 (Unexpected integer value: 1).
Yep, correct: remove the 'infile' before 'ID' and it'll run.
Regards, Steffen
hi steffen,
thanx for your answer, sorry for that mistake.
now i get
dataload table accounting.cisco3640br_200310 ID 1 SOURCE 2 DESTINATION 3 PACKETS 4 BYTES 5 TIMSTAMP 6 infile '/tmp/tmp2/cisco3640br_200310.csv' separator ';'
ERR -25319 Missing data for specified column SOURCE.
greetings thomas
-- -- # Thomas Stegbauer # http://www.keyserver.de:11371/pks/lookup?op=get&search=0xFF837A1A # Key fingerprint = E469 F5DC 42FB B530 F5CB 99CB CEB2 BFC6 FF83 7A1A
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
