I have a txt file (log) that an application writes to regularly that I want to automate import into a MySql table. I intially thought about using LOAD DATA INFILE but can not use this in a stored procedure. Any thoughts or suggestions?
Thanks in advance...
Greg