thanks! I was able to build dbf2mysql using VC++ 6.0 and
mysql/include with minor mods to endian.c. It looks like it was designed for
a bigendian system. dbf2mysql is almost as speedy as LOAD DATA so I'll use
Thanks again and epically to the MySQL developers. I will definitely
purchase MySQL support if only to reward the developers for a great job.
From: Michael Widenius [mailto:monty@stripped]
Sent: Thursday, November 29, 2001 1:37 PM
To: JR Ruggentaler
Subject: Migrating xBase files to MySQL
>>>>> "JR" == JR Ruggentaler <jr@stripped> writes:
JR> I wrote a Java app that converts the xBase files to CSV text files
JR> and used the LOAD DATA command. Load data was by far the fastest of the
JR> options I tried. Using LOAD DATA I was able to load ~99000 records in 30
JR> seconds. It took between 20 and 30 minutes using the other methods. I
JR> like to modify MySQL or write a utility to load xBase files using the
JR> underlining the LOAD DATA command. Do this sound doable?
JR> Can some suggest a starting point?
I would like to suggest that you shoud first try to modify the
db2mysql to write the result to a tab separated text file and then use
LOAD DATA to read the file into MySQL.
JR> I there any documentation on building MySQL on Win32?
If you are using Microsoft VC++, then you just have to download the
MySQL windows source and use the project files included with it to