Re: Importing data...

[Christopher R. Jones]

>I'm having trouble importing data to the mysql databases...I've read the
>docs and such, but still cant get it right...  First of all, how should the
>text file be set up? and what should the correct syntax be for mysqlimport?
>
>Thanks :)
>
>
>
>=-=-=-=
>Dayv Gastonguay
>

I use "load data infile".  See the manual, Section 7.15.  You can do it
from the command line or in a shell script (batch file).  I generate tab
deliniated files from my FileMaker Pro databases so I can use them on a WEB
server with MySQL.




Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. [phone]
Fax. [phone]
Email cj@stripped