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, '');
Error while export
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
Please login to leave a reply, or register at first.