RE: LOAD DATA INFILE in MaxDB

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 .	UPDATE DUPLICATES
	ID       1
	FIELD_A  2
	FIELD_B  3

    COMPRESSED
    ASCII SEPARATOR ';'
    DELIMITER ''
    TIMESTAMP 'YYYY-MM-DD HH:MM:SS'
    DATE 'YYYY-MM-DD'
    TIME 'HH:MM:SS'
---8<---

Command:
sdb@mydbserver:~> loadercli -n <DB_HOST> -d <INSTANCE> -u <USER>,<PASSWORD> -b <COMMAND_FILE>

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

bye
Chris

> -----Original Message-----
> From: Christian Sell [mailto:kuchri@gmx.de]
> 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/maxdb?unsub=lists@pantek.com