Reputation: 21
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