Re: How to import data from Dbase3?

[Ehrwin Mina]

BG Mahesh wrote:
Actually I prefer to dump the dbase file on a Linux machine and directly import it into MySQL.
 

Yap, it is posible to dump the file in a linux machine but you must 
import it first into a windows mysql and later you dump it to a linux 
macine mysql.

----- Original Message -----
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Ehrwin Mina" <[EMAIL PROTECTED]>
Subject: Re: How to import data from Dbase3?
Date: Wed, 23 Mar 2005 02:21:48 -0600
 

Ehrin,
If you have dBase III or later, Clipper or FoxPro, you can export 
the data comma-separated, then use a free csv-to-mysql utility eg 
http://sourceforge.net/projects/csv-mysql/ to get it into mysql.

If you don't have an xbase executable, it's a little harder, but 
not much provided there's no memo file. A dbase data file is an 
ASCII file with a binary header.  You can read the header in any 
file viewer, observe the header size, and find the field names & 
lengths. The data is entirely ASCII, padded to exact col lengths, 
thus simple  to parse with a perl or php script.

If there's a memo file, you need an xbase executable.
PB
-----
Ehrwin Mina wrote:
   

BG Mahesh wrote:
     

hi
How do I import data from Dbase3 into MySQL?
-- B.G. Mahesh
[EMAIL PROTECTED]
http://www.indiainfo.com/

       

BG,
There are tools you can use to migrate it to mysql, i use it 
before that i get it in the forum. You can search some forum 
indicating the migration tools for DB3, Foxpro, access.

thanks,
     

-- No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005
   


--
B.G. Mahesh
[EMAIL PROTECTED]
http://www.indiainfo.com/
 


--
*Ehrwin C. Mina*
*/Chikka Asia, Inc. /*
*9/F RCBC Plaza Tower 2
6819 Ayala Avenue
Makati City, Philippines
hp1: +639189304383
hp2: +639178452102*
*tel: +63-2-757-2630
fax: +63-2-757-2633
email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
*URL: **http://www.chikka.com* <mailto:[EMAIL PROTECTED]>
*This message and any attachment are confidential and may be privileged 
or otherwise protected from disclosure. If you are not the intended 
recipient, you must not copy this message or attachment or disclose the 
contents to any other person. If you have received this transmission in 
error, please notify the sender immediately and delete the message and 
any attachment from your system. Chikka does not accept liability for 
any omissions or errors in this message which may arise as a result of 
E-Mail-transmission or for damages resulting from any unauthorized 
changes of the content of this message and any attachment thereto. 
Chikka does not guarantee that this message is free of viruses and does 
not accept liability for any damages caused by any virus transmitted 
therewith.*

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]