distal-attribute
distal-attribute
distal-attribute
distal-attribute

Import error option to resume

Raksmey posted 3 years ago in Import/Export
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!
ansgar posted 3 years ago
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.