Ad:

MySQL Discussion Thread
Unsolved
Views: 2575

Jun 2nd, 2009

Automate CSV file import to MYSQL

Expand Post »

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.

Similar Threads

CSV file uploading into a MySQL Database? in PHP
Reading CSV file into a ADO recordset in ASP.NET
read second line or record of csv file in PHP
insert csv file into mysql through php in PHP
program for reading from .csv file shows errors in Java

swanside

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Sep 2007

Permalink

Jun 5th, 2009

Re: Automate CSV file import to MYSQL

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

pty

Reputation Points: 64

Solved Threads: 39

Posting Pro

Offline

530 posts
since Oct 2005

Permalink

Jun 5th, 2009

Re: Automate CSV file import to MYSQL

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

swanside

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Sep 2007

Permalink

Jun 5th, 2009

Re: Automate CSV file import to MYSQL

Click to Expand / Collapse Quote originally posted by 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

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.

pty

Reputation Points: 64

Solved Threads: 39

Posting Pro

Offline

530 posts
since Oct 2005

Permalink

Jun 6th, 2009

Re: Automate CSV file import to MYSQL

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

swanside

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Sep 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: help in query top 5th and 6th max

Next Thread in MySQL Forum Timeline: Issues installing MySQL

DaniWeb Message

Cancel Changes

User Name
Password