From: Dalton C. <dal...@gm...> - 2012-11-19 18:24:25
|
On 19 November 2012 12:52, Ann Harrison <an...@qb...> wrote: > > I assure you that MySQL dump produces a text file containing insert > statements. > > Best regards, > > Ann Oh, I believe you, as I have seen them/used them, but like I said, I could not imagine anyone (implied 'reasonable') using them for large datasets. Straight sql dumps have their place in certain limited circumstances, but, using them to load or extract large data sets is like trying to use a hammer as a wrench. I have seen dump tools for oracle that did use parametrized inserts and relative paths to individual files for each hex encoded blob. The entire dump was placed into a single zip file so that you could extract/modify/delete details as needed. Something like that could be useful as a migration tool or snapshot based backups like gbak. The only benefit in comparison to gbak would be the fact that the end user would be able to easily manipulate the output/input files. As for support, if the user screws up their data/backups by hand editing the files, that is their problem. The project should not concern itself with people who are given enough rope to climb a mountain but decide to hang themselves instead. |