Automate CSV file import to MYSQL

[swanside]

Hello.
I have a MYSQL database and I receive CSV files throughout the day.
At present I have to open up my database and import the CSV file.

Is there a exe file that can run so the CSV file can be imported as and when it arrives on the server pc?

for example, the CSV file will land in C:\CSV

Thanks
Paul.

[pty]

I think you should look at the LOAD DATA INFILE docs and cron a script to import for you

[swanside]

Thanks I will have a look at that.
Can you run CRON jobs on server 2003 or do you need some extra softwear to run it?
Thanks

[pty]

Thanks I will have a look at that. Can you run CRON jobs on server 2003 or do you need some extra softwear to run it? Thanks

Sorry didn't realise your server was Windows. I'm not an expert on Windows but I'm sure you could use a scheduled task in cron's place.

[swanside]

OK. Thanks again, I will have a look at that and see what I can do.