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 <[EMAIL PROTECTED]> To: Ted Johnson <[EMAIL PROTECTED]> Cc: mysql@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 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 <[EMAIL PROTECTED]> 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 > > > > >
