[ILUG] Large SQL File
rcunniff at stp.dias.ie
Wed Jul 7 12:23:11 IST 2004
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
Stitching the results back together is left as an exercise...
More information about the ILUG