[TriLUG] mySQL Data Import

[Myrhillion]

As silly as this may sound, have you tried contacting their admins?
They might be willing to load it for you, if you provide the commands 
that have been given as well.
This may be more expeditious than writing a php/mysql script to cycle 
through manually. heh

Doug T

Mark Freeze wrote:

>Amazingly I think that Network Solutions only lets you use a portion
>of phpadmin.  I can start phpadmin, but it only has a few options such
>as add & remove database, add & remove table, and export data.  The
>import tab and functions are missing...
>
>
>
>On 5/3/05, Robert Ryals <rryals at tmio.com> wrote:
>  
>
>>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
>>>>
>>>>
>>>>
>>>>        
>>>>
>>--
>>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
>>
>>    
>>