Monty,
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
it.
Thanks again and epically to the MySQL developers. I will definitely
purchase MySQL support if only to reward the developers for a great job.
J.R.
-----Original Message-----
From: Michael Widenius [mailto:monty@stripped]
Sent: Thursday, November 29, 2001 1:37 PM
To: JR Ruggentaler
Cc: internals@stripped
Subject: Migrating xBase files to MySQL
Hi!
>>>>> "JR" == JR Ruggentaler <jr@stripped> writes:
<cut>
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
would
JR> like to modify MySQL or write a utility to load xBase files using the
method
JR> underlining the LOAD DATA command. Do this sound doable?
Yes.
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
compile MySQL.
Regards,
Monty
