Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Error while export

sergtop's profile image sergtop posted 11 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, '');
sergtop's profile image sergtop posted 11 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, 11 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 11 years ago Permalink
Done. Thanks for the report.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.