MySQL Forums
Forum List  »  General

Re: Rollback of Unfinished Data Load
Posted by: Peter Brawley
Date: May 02, 2016 11:14AM

InnoDB treats the entire input as a single transaction, so an error rolls it back. Therefore, big files can cause big problems. Best to split them, or perhaps use MyISAM for huge reference tables.

MyISAM stops with an error. There is no resume function.

Options: ReplyQuote


Subject
Written By
Posted
Re: Rollback of Unfinished Data Load
May 02, 2016 11:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.