When exporting a table by SQL inserts, there's an option to break the inserts into chunks limited by the data size (measured in KB).
This works as expected.
However, when importing, there's often an error that Max insert rows is 1000.
Depending on how many columns and the type of data in the columns, I have to continually adjust this value.
This issue can be alleviated somewhat by clicking on the button to disable errors in batch mode, however, it also means that chunk which is over 1000 rows long does not get inserted fully.
It would be good to be able to have an option to limit by rows rather than size.
What do you good people think?