The existing dbf2mysql does not allow quick inserts(the -q) flag, which offers
up to a 2.5X speedup. This is because Versions of mysql greater than 3.23.49
and greater than 4.0.2 require the MYSQL_OPT_LOCAL_INFILE option in all clients
attempting to load data from a file. I'm attaching a new patch-ab, which allows
dbf2mysql to function properly with the mysql323-server port and any greater
version. The patch adds a -L option to tell dbf2mysql to specifically allow
local inserts. I have merged the new patch-ab with the existing patch-ab since
section 4.4 of the FreeBSD porters handbook states, "you should avoid having
more than one patch fix the same file". There aren't any conflicts with the
Note, I am not the author of this patch. I simply took the patch from the
Debian package of dbf2mysql and merged it with the FreeBSD patch-ab. The
original author is credited in the diff. I have tested the new -L feature
extensively, and it works.
Fix: Apply the following patch to fix the problem.
How-To-Repeat: Attempt to use the -q flag with dbf2mysql and a mysql server with version
greater than 3.23.49.
Over to maintainer.
Oops! I accidentally posted the unmerged patch, which clobbers the
original patch-ab. The merged patch is available here:
Maintainer, has there been any progress on this one?