 |  |  |  |  |  |  |  |
Automate CSV file import to MYSQL
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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.
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.
I think you should look at the LOAD DATA INFILE docs and cron a script to import for you
Note to self... pocket cup
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
Can you run CRON jobs on server 2003 or do you need some extra softwear to run it?
Thanks
•
•
•
•
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
Note to self... pocket cup
|
Similar Threads
- read second line or record of csv file (PHP)
- insert csv file into mysql through php (PHP)
- program for reading from .csv file shows errors (Java)
- CSV file uploading into a MySQL Database? (PHP)
- csv, convert date, mysql, php (PHP)
- Reading CSV file into a ADO recordset (ASP.NET)
Other Threads in the MySQL Forum
- Previous Thread: help in query top 5th and 6th max
- Next Thread: Issues installing MySQL
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop legal license licensing linux maintenance mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization
