MySQL Import LOAD DATA LOCAL INFILE

Question

LRNPHP 0 Junior Poster in Training

14 Years Ago

Hi There.

Is it possible to use the LOAD DATA LOCAL INFILE command from a crontab or what will the best way be of importing a csv on a hourly basis.

Regards

mysql

2 Contributors
2 Replies
282 Views
17 Hours Discussion Span
Latest Post 14 Years Ago Latest Post by LRNPHP

griswolf 304 Veteran Poster

14 Years Ago

shell> mysqlimport [options] db_name textfile1 [textfile2 ...]

See http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html and particularly, search for a comment about csv files on Windows (which you will want to alter to your specific platform)

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

LRNPHP 0 Junior Poster in Training · Answer 1 · 2010-09-08T11:02:23+00:00

shell> mysqlimport [options] db_name textfile1 [textfile2 ...]
See http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html and particularly, search for a comment about csv files on Windows (which you will want to alter to your specific platform)

Hi GrisWolf

Figured it out yesterday. Thanks for your help.

mysql -u**** -p**** database --execute="LOAD DATA LOCAL INFILE 'C:\\import.csv' INTO TABLE table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, field2, field3)"

Regards