[TriLUG] mySQL Data Import

[Mark Freeze]

I don't think that mysqlimport is enabled on NetSol's server either. 
I can't even enter mysqlimport --help, or mysqlimport -?  without
getting errors.

Is there any other way to import my data into a table?  I was thinking
maybe someone could show me how to loop through the local file with
php and update each field manually. I can't think of anything else.

Regards,
Mark.

On 5/2/05, Matt Frye <mattfrye at gmail.com> wrote:
> > copy the file name to pfs_trans, then run:
> >
> > mysqlimport --fields-terminated-by='\t' --lines-terminated-by='\r\n' pfs_trans
> 
> oh, and don't forget credentials...
> 
> mysqlimport --fields-terminated-by='\t' --lines-terminated-by='\r\n'
> pfs_trans [ -u username -p ] databasename
> 
> MPF
> --
> TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
> TriLUG Organizational FAQ  : http://trilug.org/faq/
> TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
> TriLUG PGP Keyring         : http://trilug.org/~chrish/trilug.asc
>