[TriLUG] mySQL Data Import

[Matt Frye]

On 5/2/05, Mark Freeze <mfreeze at gmail.com> wrote:
> I am trying
> to import a tab-delimited data file...The system gives me the error 'Command
> used is not supported in this version of MySQL.'
> 
> What is the next best way to get my 1000 record file imported into a
> MySQL table?

copy the file name to pfs_trans, then run:

mysqlimport --fields-terminated-by='\t' --lines-terminated-by='\r\n' pfs_trans



MPF