Jump to content


Photo

Multiple File Import


  • Please log in to reply
1 reply to this topic

#1 vip3r

vip3r
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 19 April 2006 - 03:03 PM

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.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

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