From: Mogens Melander
Date: April 19 2007 11:19am
Subject: Re: Trying to open a big sql script
List-Archive: http://lists.mysql.com/mysql/206256
Message-Id: <2582.90.184.17.152.1176981544.squirrel@mail.fumlersoft.dk>
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit


On Thu, April 19, 2007 12:48, Duncan Hill wrote:
> On Thursday 19 April 2007 11:43:34 molemenacer 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?
>
> You need an editor that will only load the current view of the file into
> memory.  I'm not sure that such a beast exists, other than stream editors
> such as sed or perl.  Can the changes you need to make be done with stream
> editing (simple changes like changing a word or two are very easy with
> stream
> editor)?

Also, replace from your mysql-installation could be used,if
you only need to replace "a-string" with "b-string" :)

-- 
Later

Mogens Melander
+45 40 85 71 38
+66 870 133 224




-- 
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.