That's a much larger file than most any text editor would work with, in my
experience. I'd give BBEdit on the Mac a try if nothing else, but my
expectations would not be too high.
For examining and altering a file that large I'd try grep, awk, sed, perl,
Barring that, one thing you might do is use perl or another scripting
language (or perhaps some utility software) to read the file in 100 MB or so
chunks and write out to a series of smaller files. Edit the smaller files,
then use shell command to cat them all back into one bigger file.
On 4/19/07, molemenacer <rossfarley@stripped> wrote:
> Hi all,
> I have backed up a database using mysqldump and have a .sql script that is
> over 2GB in size. I am trying to open this file to view it and make some
> changes. I have not been able to find a program that can open this file.
> Does anyone have any suggestions as to a program that can do this?
> Thanks in advance
> View this message in context:
> Sent from the MySQL - General mailing list archive at Nabble.com.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1