[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-internals
Subject:    RE: Migrating xBase files to MySQL
From:       JR Ruggentaler <jr () mpv ! com>
Date:       2001-11-29 18:59:01
[Download RAW message or body]

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@mysql.com]
Sent: Thursday, November 29, 2001 1:37 PM
To: JR Ruggentaler
Cc: internals@lists.mysql.com
Subject: Migrating xBase files to MySQL



Hi!

>>>>> "JR" == JR Ruggentaler <jr@mpv.com> 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

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail internals-thread2393@lists.mysql.com
To unsubscribe, e-mail <internals-unsubscribe@lists.mysql.com>

[prev in list] [next in list] [prev in thread] [next in thread]