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 ..