SEO

#1 (**permalink**) 02-27-2008, 09:33 PM

107Hi;
Is there a command by which I can read the names of databases in amysqldump without expanding the dump into my mysql instance (and thus overwriting databases already extant)?
TIA,
Ted

#2 (**permalink**) 02-27-2008, 09:33 PM

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@yahoo.com> 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 Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Readind a Dump W/o Expanding It