[TriLUG] mySQL Data Import

[Robert Ryals]

Mark Freeze wrote:

>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.
>
>  
>

I could not live without phpMyAdmin.  It's a web interface written in 
php to manage Mysql databases.  You can create tables, import and export 
data, manage security, etc.

http://www.phpmyadmin.net

Robert

>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
>>
>>    
>>