[Gllug] mysqlimport

[Jackson, Harry]

> -----Original Message-----
> From: Jackson, Harry [mailto:HJackson at colt-telecom.com]
> 
> Hi all
> 
> 	Why Why Why does this not work but insists on giving me the help
> output for mysqlimport (It thinks its funny)
> 
> mysqlimport -d -u root -h localhost -pblahblah  
> --fields-terminated-by=','
> --fields-optionally-enclosed-by='"' remedy_harry  remedy.csv
> 
> 	and this does
> 
> mysqlimport -d -u root -h localhost -pahoghill 
> --fields-terminated-by=','
> remedy_harry  remedy.csv
> 
> 	Except that the later is a pile of poo in the table

For those of you that are interested I managed to get it to work by
surrounding everything in " as opposed to ' .

mysqlimport -d --debug=[1] -u root -h localhost -pblahblah
--fields-terminated-by="," --fields-enclosed-by="""
--lines-terminated-by="\r" remedy_harry remedy.csv

I am now able to run a batch script everynight to populate the database.
yipee
Harry


**********************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. 020 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or 
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message.  Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.


**********************************************************************

-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug