abdoulclub-internet.fr
Date: Fri Mar 05 2004 - 15:45:31 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello,

I'd like to know how can I load a huge amount of sql statements from a file .

I'm trying with :

-dbmcli

-xsql

-loadercli

-sqlcli

 
witch is the best suitable for this task?

 here is a sample of the data file :

 --

 create table ABContact (
        contactId varchar(100) not null primary key,
        userId varchar(100) not null,
        firstName varchar(100),
        lastName varchar(100),
        emailAddress varchar(100),
        homeStreet varchar(100),
         homeCity varchar(100),
        homeState varchar(100),
        homeZip varchar(100),
        homeCountry varchar(100),
        homePhone varchar(100),
        homeFax varchar(100),
        homeCell varchar(100),
        businessCompany varchar(100),
        businessStreet varchar(100),
        businessCity varchar(100),
        businessState varchar(100),
        businessZip varchar(100),
        businessCountry varchar(100),
        businessPhone varchar(100),
         businessFax varchar(100),
        businessCell varchar(100),
        birthday timestamp,
        instantMessenger varchar(100),
        website varchar(100)
);

--

I tried with the command : /opt/sdb/programs/bin/loadercli -u x,x -d $SID -b file.sql -E 20 but with no success.
 
If you have any clue , thanks in advance.

AB

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]