That worked! It's there! Now...how can I rebuild *just* that database (which was removed
from my MySQL server) without affecting the other databases?
TIA,
Ted
----- Original Message ----
From: Dan Buettner <drbuettner@stripped>
To: Ted Johnson <whatawonderfulworldweliveintoo@stripped>
Cc: mysql@stripped
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 Database: outsell_web_prod
and the command above finds that line. Getting a little fancier with
grep could filter the excess out of the line.
Hope this helps,
Dan
On 10/14/06, Ted Johnson <whatawonderfulworldweliveintoo@stripped> wrote:
> 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
>
>
>
>
>
