Re: Question about importing alot of data to mysql several times a day.

2005-11-07 Thread Gleb Paharenko
Hello. Have you seen comments at the bottom of: http://dev.mysql.com/doc/refman/5.0/en/load-data.html In my opinion, there are some solutions which should point you in the right direction, however I'm not sure if they're quick enough. Lindsey wrote: > So wich is the recomended way

Question about importing alot of data to mysql several times a day.

2005-11-07 Thread Lindsey
So wich is the recomended way to import alot of data several times a day to mysql? I´m going to recive ~40 csv-files 3-4times a day which need to be imported. Each file contains around 10.000-50.000 items. My guess is to use LOAD DATA... BUT i only want to import the items with an ID- number that