Buettner [EMAIL PROTECTED]
To: Ted Johnson [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Sunday, October 15, 2006 8:45:07 PM
Subject: Re: Re: Re: Re: Readind a Dump W/o Expanding It
Ted - sorry, not sure what this is showing me. Is the image data
supposed to be in the data field in the Photo
:57 AM
To: Dan Buettner
Cc: mysql@lists.mysql.com
Subject: Re: Re: Re: Re: Readind a Dump W/o Expanding It
8080The data field's a text field, not a blob! That's the
problem, there are no blobs, and I just wanted a second set
of eyes on this to confirm what simply makes no sense at all!
I'd
Subject: Re: Re: Readind a Dump W/o Expanding It
That's a little trickier, but definitely possible. I can think of 3
ways to do it, I'm sure there are others.
Approach #1, works if your dumpfile is a manageable size:
- make a copy and work from the copy
- open the copy in a text editor, and find
, 2006 9:59:31 PM
Subject: Re: Re: Readind a Dump W/o Expanding It
That's a little trickier, but definitely possible. I can think of 3
ways to do it, I'm sure there are others.
Approach #1, works if your dumpfile is a manageable size:
- make a copy and work from the copy
- open the copy in a text
74- Original Message
From: Dan Buettner [EMAIL PROTECTED]
To: Ted Johnson [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Sunday, October 15, 2006 9:22:04 AM
Subject: Re: Re: Re: Readind a Dump W/o Expanding It
How were they stored in the database?
You got me on that. I just took
[EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Sunday, October 15, 2006 9:22:04 AM
Subject: Re: Re: Re: Readind a Dump W/o Expanding It
How were they stored in the database?
You got me on that. I just took over this box. Here's what my queries show:
server167# mysqlshow -uroot -p tirekingdom
107Hi;
Is there a command by which I can read the names of databases in a mysqldump
without expanding the dump into my mysql instance (and thus overwriting
databases already extant)?
TIA,
Ted
Ted, if you're on a *NIX variant, you could use grep. Something like:
cat DUMPFILE | grep Database: | grep Host:
A dump file I have laying about has a line like this:
-- Host: localhostDatabase: outsell_web_prod
and the command above finds that line. Getting a little fancier with
grep
: Saturday, October 14, 2006 9:41:46 AM
Subject: Re: Readind a Dump W/o Expanding It
Ted, if you're on a *NIX variant, you could use grep. Something like:
cat DUMPFILE | grep Database: | grep Host:
A dump file I have laying about has a line like this:
-- Host: localhostDatabase: outsell_web_prod
@lists.mysql.com
Sent: Saturday, October 14, 2006 9:41:46 AM
Subject: Re: Readind a Dump W/o Expanding It
Ted, if you're on a *NIX variant, you could use grep. Something like:
cat DUMPFILE | grep Database: | grep Host:
A dump file I have laying about has a line like this:
-- Host: localhost
10 matches
Mail list logo