Load infile query issue in mysql We are using Load data infile query to load txt files in the database (mysql) .

we have a continues flow of text files to process using load query and is dumped in the table

but sometimes the load query just stops processing the files .. 

we are not able to get what is causing this issue .. 

is there anyway we could generate the sql exception or server exception to know what could have caused the problem to distinguish if its a server problem or the file problem ..
check the following link : 

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

It will help you in detail about the Load infile query issue in mysql