Importing Csv Files Into Mysql Database

[bkelley]

Hi, I am a new user trying out SQLyog, and I looked through the blog for this answer, but was not able to find something that works. I have a 90 column CSV data file with about 250,000 records. I need to import only 15 of those columns/fields into my MySQL database. Everytime I try to do with either “Import CSV data” or “Import external data” it either truncates the data, times out, or gives me a range of other issues. I expect that this is a common task, so it should be easy, but so far I've not been able to make it work. The file is too large for PhPAdmin. Can someone give me some advice?

thanks very much, Brian

[peterlaursen]

What is the program version you are using?

Actually there are two ways to import a CSV-file:

1) Using SQL-statement LOAD DATA INFILE

2) Using ODBC and the Microsoft text-ODBC-driver

A detailed description of what you do (screenshots etc.) would help.

If data are truncated that must be because the colums you are importing to are too short.

Maybe you can attach/paste

* the CREATE TABLE statement for the tbale you are importing to

* a sample CSV file. In principle the first 10 rows/lines of your existing file would probably be OK.

(create a support ticket if you want privacy)

[Author]

Posts