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
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
