Mandy Li
Mandy Li

Reputation: 21

MYSQL Rollback with a set of LOAD DATA INFILE

I use a batch file to load my tables from CSV files using numerous LOAD DATA INFILE commands. When an error occurs during one of a table's LOAD statements, rollback occurs only for that table with 0 rows, while the data in other tables remains committed. Please advise on how to make this transaction-bound. I discovered a similar article here MySQL: Executing LOAD statements inside Transaction from a sql script file, however there is no answer.

Upvotes: 1

Views: 220

Answers (0)

Related Questions