Re: Trying to open a big sql script

2007-04-20 Thread Joerg Bruehe
Hi! Duncan Hill wrote: On Thursday 19 April 2007 15:53:54 molemenacer wrote: I am trying to change all the names of the database from mthosp to another name, is this possible? Assuming you mean tables, not database (as mysqldump doesn't store the database name in the dump file [or at least

Re: Trying to open a big sql script

2007-04-20 Thread Gerald L. Clark
Joerg Bruehe wrote: Hi! Duncan Hill wrote: On Thursday 19 April 2007 15:53:54 molemenacer wrote: I am trying to change all the names of the database from mthosp to another name, is this possible? Assuming you mean tables, not database (as mysqldump doesn't store the database name in

Re: Trying to open a big sql script

2007-04-19 Thread Duncan Hill
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

Re: Trying to open a big sql script

2007-04-19 Thread Dan Buettner
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

Re: Trying to open a big sql script

2007-04-19 Thread Mogens Melander
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

Re: Trying to open a big sql script

2007-04-19 Thread Michael Dykman
It might be a little late for this advice but mysqldump has some useful options for this kind of thing. When I use it to create full snapshots, I use a script which generates a separate schema file per table/view and keep the data in one or more per table for data. naming conventions keep keep

Re: Trying to open a big sql script

2007-04-19 Thread molemenacer
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

Re: Trying to open a big sql script

2007-04-19 Thread Duncan Hill
On Thursday 19 April 2007 15:53:54 molemenacer wrote: I am trying to change all the names of the database from mthosp to another name, is this possible? Assuming you mean tables, not database (as mysqldump doesn't store the database name in the dump file [or at least never has for me]): sed

Re: Trying to open a big sql script

2007-04-19 Thread Mogens Melander
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

RE: Trying to open a big sql script

2007-04-19 Thread Andreas Iwanowski
If you are under windows, you should try Textpad (http://www.textpad.com/) In any case, a hex editor will do what you're looking for. Hope to help, Andy -Original Message- From: molemenacer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 6:44 AM To: mysql@lists.mysql.com