[ILUG] Large SQL File

[Denis Hennessy]

Use split to break the file apart into manageable chunks. Something like:

$ split --lines=10000 huge.sql

/dh

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!
>
> Any suggestions?
> Best Regards
> Robert