Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
Re: Data load problem with "dataload " command
From: Bhanu Vasireddy (sepra1972yahoo.com)
Date: Fri Jun 11 2004 - 18:41:03 CDT
Thanks for your response. you are right, because of log files the process is hanging after loading certain amount of records from source file. using following commands I turned logging off and I was able to load all the records(>100000) from the source file.
dbmcli -d <db> -u <dbmuser,dbmpass>
> util_execute SET LOG WRITER OFF
After executing above commands to turn logging off, i am having problem to access my database with resource type user id. some times even its not letting me to log in as DBA( -u dba,dba = wrong userid and password message), any ideas. if i login as db_admin then does process force DB kernel to disable other users like dba and other resource users?
Once again thanks for your help.
"Brunzema, Martin" <martin.brunzemasap.com> wrote:
> -----Ursprüngliche Nachricht-----
> Von: Bhanu Vasireddy [mailto:sepra1972yahoo.com]
> Gesendet: Donnerstag, 10. Juni 2004 23:09
> An: maxdblists.mysql.com
> Betreff: Data load problem with "dataload " command
> I am having problem to load massive data into table . i have
> around 750000 rows in the
> source file in following format
> "asdf","1","this is my data"
> "asdg","2","This is my data2"
> and here are my table definition and load command
> create table TERM_DETAILS(
> term varchar(20) primary key,
> ID integer not null,
> details varchar(3000) default 'none')
> dataload table TERM_DETAILS IGNORE DUPLICATES infile 'terms.txt'
> after executing above commands process is loading around
> 400000 rows in 10 to 15 minutes and simply hanging. is anyone
> successfully loaded millions of rows in MaxDB
have a look into the file knldiag. Maybe you'll find there an error-message.
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=matt.woodsadsdish.com
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around