[TriLUG] mySQL Data Import
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.
> 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.
> >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
> >>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