List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:April 19 2007 5:06pm
Subject:Re: Trying to open a big sql script
View as plain text  
Something like this should do the trick:

~#replace "mthosp" "newname" < org-file.sql > new-file.sql

-- 
Later

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


On Thu, April 19, 2007 16:53, molemenacer wrote:
>
> I am trying to change all the names of the database from mthosp to another
> name, is this possible?
>
>
> Dan Buettner-2 wrote:
>>
>> 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,
>> etc.
>>
>> 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.
>>
>> HTH,
>> Dan
>>
>>
>> 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:
>>>
> http://www.nabble.com/Trying-to-open-a-big-sql-script-tf3606302.html#a10075570
>>> 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
>>>
>>>
>>
>>
>
> --
> View this message in context:
> http://www.nabble.com/Trying-to-open-a-big-sql-script-tf3606302.html#a10078655
> 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
>
>
> --
> This message has been scanned for viruses and
> dangerous content by OpenProtect(http://www.openprotect.com), and is
> believed to be clean.
>



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

Thread
Trying to open a big sql scriptmolemenacer19 Apr
  • Re: Trying to open a big sql scriptDuncan Hill19 Apr
    • Re: Trying to open a big sql scriptMogens Melander19 Apr
      • Re: Trying to open a big sql scriptMichael Dykman19 Apr
  • Re: Trying to open a big sql scriptDan Buettner19 Apr
    • Re: Trying to open a big sql scriptmolemenacer19 Apr
      • Re: Trying to open a big sql scriptDuncan Hill19 Apr
        • Re: Trying to open a big sql scriptJoerg Bruehe20 Apr
          • Re: Trying to open a big sql scriptGerald L. Clark20 Apr
      • Re: Trying to open a big sql scriptMogens Melander19 Apr
RE: Trying to open a big sql scriptAndreas Iwanowski20 Apr