Import error option to resume

User, date Message
Written by Raksmey
3 years ago
Category: Import/Export
1 posts since Mon, 05 Sep 11
I have using import feature to import sql file which size is about 200MB and then the import process run for a while and throw an error! as such
/* SQL Error (1136): Column count doesn't match value count at row 841 */
or My Sql runaway
and I wonder is there a way to ignore it and resume to the next query?

Thanks in advance!
Written by ansgar
3 years ago
5023 posts since Fri, 07 Apr 06
Not in the "run query" dialog. Only if you load the file into the query editor, you can unpress the button on the main toolbar "Stop on errors in batch mode". But I guess it'd be the best to open the file with an editor and fix the problems in it. You are going to blindly ignore things otherwise, and you will end up with a totally inconsistent backup.

Please login to leave a reply, or register at first.