padmapraveen_vasili Posted August 20, 2008 Share Posted August 20, 2008 Hi all,I need you help in implementing this module for my application.I am using mySQL 5.0.51 on my windows machine -- for development.The application is being developed in Java.I have a table in MySQL, which needs a daily feed to run ar mid night.It is a CSV or may be delimited .TXT file.can any one help me, in automating the process of given file, located in local drive to upload daily at given particular time.does it need any triggers or functions to be developed for thsi job.how to use a scheduler for this functionality....please let me know your opinions and solutions.thanks in advance..regardspraveen. Link to comment Share on other sites More sharing options...
justsomeguy Posted August 20, 2008 Share Posted August 20, 2008 If the application is on the same computer as MySQL then you can use this tool with the command line:http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.htmlFor scheduling, Windows has the Task Manager and Linux has cron. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.