[ILUG] Large SQL File
denis at hennessynet.com
Wed Jul 7 12:30:01 IST 2004
Use split to break the file apart into manageable chunks. Something like:
$ split --lines=10000 huge.sql
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
More information about the ILUG