I was able to get data out of Filemaker Pro on a mac and import it into
MySQL. I exported as a comma separated text file.

here is the command to import the data:

LOAD DATA LOCAL INFILE "mydata.txt" INTO TABLE mydata FIELDS TERMINATED BY
',' ENCLOSED BY '"';

just keep your fields in synch; the field order and data type in the MySQL
database should match those in the text file.

Gavin


on 10/16/00 8:27 AM, J A Shamsi  wrote:

> Hi
> 
> I have a windows and a linux machine.
> I want to import the database from windows
> to linux running mysql.
> I have an option of importing it as a text file or dbf
> file.
> 
> any idea can I import it through mysql or
> do I have to mount the windows m/c to linux.
> or id there any possibilty through web sharing?
> 
> 
> thanks in advnace


Keep in touch with http://mandrakeforum.com: 
Subscribe the "[EMAIL PROTECTED]" mailing list.

Reply via email to