[ILUG] Large SQL File

[Robert Sweetnam]

On Wednesday 07 July 2004 12:23, Ronan Cunniffe wrote:
> On Wed, 7 Jul 2004, Robert Sweetnam wrote:
> > Hello All,
> >
> > I have an SQL file that I want to dump into MySQL however whenever I
> > attempt I get an error on a line number thats well down the script.
> > The problem is that file itself is over 1GB in size and I cant get any
> > text editor (vi or emacs) to open it!
>
> sed -n '10,50p' <infile >outfile
>
> will dump lines 10-50.  (If you leave out the -n, you'll see why I left it
> in :-)
>
> Stitching the results back together is left as an exercise...
>
> Ronan

Thats brilliant, Ronan, Thanks a million. Keep an eye out for my post on how 
to stitch them back together :)
How could I remove those lines altogether from the original file?

Best Regards
Robert