RE: LOAD DATA INFILE and how to ignore garbage lines at end ofload file?

2002-03-05 Thread Baines, Dominic
2002 16:33 To: Richard Bolen; MySQL Mailing List (E-mail) Subject: Re: LOAD DATA INFILE and how to ignore garbage lines at end ofload file? At 10:58 -0500 3/4/02, Richard Bolen wrote: >I'm exporting data from Oracle and importing it into MySQL. The >problem is Oracle puts garbage lin

RE: LOAD DATA INFILE and how to ignore garbage lines at end ofload file?

2002-03-04 Thread Richard Bolen
st (E-mail) Subject: Re: LOAD DATA INFILE and how to ignore garbage lines at end ofload file? At 10:58 -0500 3/4/02, Richard Bolen wrote: >I'm exporting data from Oracle and importing it into MySQL. The >problem is Oracle puts garbage lines at the end of it's output files. As you'

Re: LOAD DATA INFILE and how to ignore garbage lines at end ofload file?

2002-03-04 Thread Paul DuBois
At 10:58 -0500 3/4/02, Richard Bolen wrote: >I'm exporting data from Oracle and importing it into MySQL. The >problem is Oracle puts garbage lines at the end of it's output files. As you've noted, the problem is Oracle. If you're using Unix, you could use tail to see how many of these lines th