PDA

View Full Version : Schedule MySQL imports?


jhoover667
02-21-2000, 12:53 PM
I'm not a Unix/Linux guy so I need some help from some of you who are.[nbsp][nbsp]I'd like to be able to have a CRON routine run every hour that watches a folder.[nbsp][nbsp]Once the folder gets a file, I'd like to run a MySQL import.[nbsp][nbsp]Once the import is finished, I'd like to move the file to another folder so that it doesn't get picked up the next time the CRON routine runs.[nbsp][nbsp]Any ideas on how I would go about this?[nbsp][nbsp]I'm especially stuck on making the MySQL part of the task/routine automated.[nbsp][nbsp]All help is greatly appreciated!