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 the

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 n

RE: Trying to open a big sql script

2007-04-19 Thread Andreas Iwanowski
l.com Subject: Trying to open a big sql script 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 hav

Re: Trying to open a big sql script

2007-04-19 Thread Mogens Melander
[EMAIL PROTECTED]> 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 >&g

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 molemenacer
ave 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 arc

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 the

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 hav

Re: Trying to open a big sql script

2007-04-19 Thread Dan Buettner
y 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://lis

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. > >

Trying to open a big sql script

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