[ILUG] Large SQL File
David Giles
pppenguin at utvinternet.com
Wed Jul 7 12:22:22 IST 2004
On Wednesday 07 July 2004 12:00, 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
use 'split' command, edit and put it back together with cat?
If you just want to view it: less
All the best,
David
More information about the ILUG
mailing list