I have developed a web application where users will have to import data into an Innodb table from csv files. The files has about 15000 records. Am using a mysql procedure where the procedure is called after reading each one of the lines in the data file. My problem is that incase of a failure (e.g. power failure) i would like to use the ACID property such that the process is undone if the entire file is not imported.
Any help will be appreciated.