I ran into this the other day, and while the solution is documented in the manual, it was kind of buried, so I thought I’d mention it here (and hopefully make it easier for others searching for this in the future).
In this specific instance, one was running a huge LOAD DATA (10 hours into it) and had to terminate the LOAD DATA command.
Terminating the command is one thing, but preventing InnoDB from trying to undo the rows that were inserted is another.
In this case, the LOAD DATA will easily re-create the table in question, so the existing table can be “thrown out”, so to speak. This, of course, is …[Read more...]