vip3r Posted April 19, 2006 Share Posted April 19, 2006 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. Quote Link to comment Share on other sites More sharing options...
fenway Posted April 19, 2006 Share Posted April 19, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.