Import error option to resume

[expired user #5907]'s profile image [expired user #5907] posted 13 years ago in Import/Export Permalink
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's profile image ansgar posted 13 years ago Permalink
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.