I have a mysql web database that I import a text file into everyday. How can I automate this process? I currently use the "load data infile" statement to import the txt file and this works great. I am using linux redhat. I know I can use "cron" to schedule and run tasks in linux and use the batch feature of mysql, but how do I put it all together? Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I automate data import?
- Thread starter kenya88
- Start date