Error while export

[expired user #4516]'s profile image [expired user #4516] posted 14 years ago in General Permalink
I`m trying to export appr. 300mb database. one of the tables is 280000 rows. While dumping this table program makes several iterations - 88413 rows per iteration. the first iteration makes correct dump (tested on export to other db), but the second one generates not correct sql, and so export of this table fails.

generated on first iteration
INSERT INTO `view` (`id`, `add_info`) VALUES (87987, '');

generated on second iteration
INSERT INTO `view` (`id`, `add_info`) VALUES (`id`, `add_info`) VALUES (88420, '');
[expired user #4516]'s profile image [expired user #4516] posted 14 years ago Permalink
seems that this error is in tabletools.pas near 1090 - 1103.
could you please fix it, as it is impossible to dump\copy tables larger then 100mb
Code modification/commit from ansgar.becker, 14 years ago, revision 2976
Fix incorrect base SQL for large SQL dumps which need more than 100MB loop. Reported via forum: http://www.heidisql.com/forum.php?t=4769
ansgar's profile image ansgar posted 14 years ago Permalink
Done. Thanks for the report.

Please login to leave a reply, or register at first.