Jump to content

Archived

This topic is now archived and is closed to further replies.

vip3r

Multiple File Import

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.