doubt in "mysqlimport" command

[sadhiesh]

I have a text file with column delimter as '/t' and row delimter as '/n'.

I used following command to import that text file into mysql DB.

C:\WINNT\mysql\bin>mysqlimport -C -f --debug='d:t,debug.txt' -d --fields-termi
nated-by='\t' --lines-terminated-by='\n' -v --local example "c:\winnt\mysql\text
s\CEIDMTL.tab"

But command is unsucessful. And giving the following output.

Connecting to localhost
Selecting database example
Deleting the old data from table ceidmtl
Loading data from LOCAL file: c:/winnt/mysql/texts/CEIDMTL.tab into ceidmtl
example.ceidmtl: Records: 1 Deleted: 0 Skipped: 0 Warnings: 18
Disconnecting from localhost

Where does i do wrong. More over i could not see the detailed messege of warning. How could i see the detailed messege of warnings?

 

[devnull22]

Hi Sadhiesh,
why don't you connect to your mysql sever and use the LOAD DATA INFILE statement?

mysq> LOAD DATA INFILE 'debug.txt' INTO TABLE table_name
FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';

hope this helps devnull22

http://www.photoflux.com

http://www.clickEval.com

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !

 

[sadhiesh]

hai devnull

thanks for ur response. but i have a problem using LOAD DATA
because it reads only row by row, where as i have a record of 80,000 , which takes a lot of time for such operation.so i thought of going in for mysqlimport which takes file by file, so could reduce the time greatly.please try solving my problem.

thanks and regards
Sadhiesh