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
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
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
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
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
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
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
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
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
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
10 matches
Mail list logo