How can I import multiple files into MySQL, basically I will be importing files from a specific directory every 15mins and so far have not been able to do this with MySQL. The files will have different file names and I would like to be able to delete the file or move the file once it has been processed.
Multiple File Import
1 reply to this topic
Posted 19 April 2006 - 03:17 PM
Well, provided you set a CRON job, you can manage the files yourself on a regular iterval (e.g. poll a directory for files), and then issue a command-line query to run SQL statements or LOAD DATA INFILE from whatever files are present.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users