Re: [Sheflug] MySQL help

[Steve Tickle <xxxxx [at] xxxxxxxxxxxxxx>]

At 15:42 24/04/02 +0100, Ruth Gunstone wrote:

>I've been doing some imports to MySQL recently, and (as far as I can tell!)
>they appear to have gone o.k. - or rather they did /after/ I'd loaded the
>data into a text/data editor (vim should do it?) and searched-out a load of
>'odd' characters that the originating database had left behind (&OE). I
>replaced them with a space (&20) and all was well.
>
>Suggestion: Try dropping the excel data into another format first (say
>Gnumeric? or the KOffice spreadsheet and see if that exports TSV more
>efficiently/correctly?)

I've done it using mysqlimport and it seems to be OK (at least the errors 
that were present originally are no longer there... there may be others)

Odd really, since the syntax for the mysqlimport command is not at all 
dissimilar to the load data infile command that I was using.


Steve

___________________________________________________________________

Sheffield Linux User's Group -
http://www.sheflug.co.uk/mailfaq.html

  GNU the choice of a complete generation.