[TriLUG] mySQL Data Import

Mark Freeze mfreeze at gmail.com
Tue May 3 09:47:33 EDT 2005


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
>



More information about the TriLUG mailing list