List:General Discussion« Previous MessageNext Message »
From:Dan Buettner Date:October 14 2006 1:41pm
Subject:Re: Readind a Dump W/o Expanding It
View as plain text  
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
>
>
>
>
>
Thread
Readind a Dump W/o Expanding ItTed Johnson14 Oct
  • Re: Readind a Dump W/o Expanding ItDan Buettner14 Oct
Re: Readind a Dump W/o Expanding ItTed Johnson14 Oct
  • Re: Re: Readind a Dump W/o Expanding ItDan Buettner15 Oct
Re: Re: Readind a Dump W/o Expanding ItTed Johnson15 Oct
  • Re: Re: Re: Readind a Dump W/o Expanding ItDan Buettner15 Oct
Re: Re: Re: Readind a Dump W/o Expanding ItTed Johnson15 Oct
  • Re: Re: Re: Re: Readind a Dump W/o Expanding ItDan Buettner16 Oct
Re: Re: Re: Re: Readind a Dump W/o Expanding ItTed Johnson16 Oct
  • RE: Re: Re: Re: Readind a Dump W/o Expanding ItJerry Schwartz16 Oct