Hi Chris, nope there's not a statement like LOAD DATA INFILE. You have to use the loader(cli) instead. For CSV data it's quite useable but has some limitations about BLOBs (have to be in a separate file), new-line in strings (not allowed) etc.
<http://dev.mysql.com/doc/maxdb/en/59/025741c0c28447e10000000a1550b0/content .htm> Just have a look at the documentation about it. I think DATALOAD will be your friend. Here's an example: Sample of an import-specification-file: ---8<--- DATALOAD TABLE <SCHEMA>.<TABLENAME> UPDATE DUPLICATES ID 1 FIELD_A 2 FIELD_B 3 INFILE '<INPUT_FILE>' COMPRESSED ASCII SEPARATOR ';' DELIMITER '' TIMESTAMP 'YYYY-MM-DD HH:MM:SS' DATE 'YYYY-MM-DD' TIME 'HH:MM:SS' ---8<--- Command: [EMAIL PROTECTED]:~> loadercli -n <DB_HOST> -d <INSTANCE> -u <USER>,<PASSWORD> -b <COMMAND_FILE> bye Chris > -----Original Message----- > From: Christian Sell [mailto:[EMAIL PROTECTED] > Sent: Friday, July 13, 2007 1:14 PM > To: maxdb@lists.mysql.com > Subject: LOAD DATA INFILE in MaxDB > > > Hello, > > > > I'm just trying to replace the MySQL Database by a MaxDB. > Unfortunately I > used quite a lot of "LOAD DATA INFILE" statements to speed up > INSERTS with a > lot of entries. Is there this or an alternative statement for > the MaxDB too? > > > > > Kind regard > > Chris > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
