[ILUG] Large SQL File

[Ronan Cunniffe]

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