[ILUG] Large SQL File
sweetr at eircom.net
Wed Jul 7 12:45:28 IST 2004
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...
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?
More information about the ILUG