MYSQL IMPORT

[prav5110]

HI Guys,

AM importing a CSV file having 136000 rows to access DB, the import takes place in 2 mins. When I do the same to an MYSQL server table, it imports 54000 records only and that too in 1 hr.

Could you help?

 

[QatQat]

Not enough information to answer.

What are you running? Linux, windoz.

Are you usign a GUI or mysqlimport?

Post your MySQLimport script if you are using it. If you are using a GUI that could be your problem. Try using mysqlimport.


Bye

Qatqat



Life is what happens when you are making other plans.

 

[prav5110]

HI,

thanx for your help so far. Well am using windows NT . When i tried importing the csv file using script like

load data infile 'C:\\LucentNonPerfRpts.csv' into table tblluc_non_perf fields terminated by ',' enclosed by '"' lines terminated by '\r\n';

It imported only 29000 rows, now am using a GUI called NAVICAT and am able to import 58000 rows.

 

[QatQat]

I have never heard of NAVICAT

I usually use mysqlimport

http://www.mysql.com/doc/en/mysqlimport.html

You may try it but I think that mysqlimport utility issues a LOAD DATA INFILE command so I don't know if it is going to make any difference.

Bye

Qatqat

Life is what happens when you are making other plans.