MySQL: Skip INSERT / UPDATE statement that triggers error but show them in output
it is 2 different problem

1st is possible errors, for this You can use --force option

mysql -u user -p --force database &lt;


and 2nd is speed

for speed You can check server configuration and adjust it if necessary:


memory (innodb)
size of redo log file, default is too small, You can increase it


because You are already have dump file - no reason discuss about single transaction or group transactions.