myloader needs to handle errors better

[Andrew Hutchings]

Errors like this need to be handled better. Maybe a retry option?

** (myloader:19336): CRITICAL **: Error restoring xxxxx.xxxxx from file xxxxx.xxxxx.00005.sql: Lock wait timeout exceeded; try restarting transaction

[bobby hakimi (bhakimi26)]

Can we please add this? it really helps. was thinking about commenting out this part of the code

                                if (mysql_real_query(conn, data->str, data->len)) {
                                        //g_critical("Error restoring %s.%s from file %s: %s", db ? db : database, table, filename, mysql_error(conn));
                                        errors++;
                                        return;
                                }

[Max Bubenick (max-bubenick)]

Hi you can reduce the --queries-per-transaction to avoid those errors when you have chunks.