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 merge. 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.
Responsible Changed From-To: freebsd-ports-bugs->jedgar Over to maintainer.
Oops! I accidentally posted the unmerged patch, which clobbers the original patch-ab. The merged patch is available here: http://ppb-envlabs.com/patches/dbf2mysql/patch-ab Thanks, Travis
State Changed From-To: open->feedback Maintainer, has there been any progress on this one?
State Changed From-To: feedback->closed Committed, thanks!