That worked! Thanks! However, when I restored the database, it seemed to have trashed all
the images. What do?
TIA,
Ted
----- Original Message ----
From: Dan Buettner <drbuettner@stripped>
To: Ted Johnson <whatawonderfulworldweliveintoo@stripped>
Cc: mysql@stripped
Sent: Saturday, October 14, 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 editor, and find the line where your
database starts. Delete everything above it.
- locate the line where the next database starts, and delete
everything below it.
- save
- pipe your altered file back into MySQL. You may need to CREATE
DATABASE first.
Approach #2, works if your dumpfile is not a manageable size
- make a copy and work from the copy
- using something like perl, open the copy and read line by line until
you encounter where your database starts. Then continue reading but
also writing out to a new file until you encounter the next line where
a database starts. Close files and exit the script at that point.
- pipe your output file back into MySQL. You may need to CREATE DATABASE first.
Approach #3, works if you have a 2nd mysql server at your disposal
- pipe full dumpfile into a MySQL installation
- use mysqldump to dump just the database in question
- pipe that dumpfile into your original server
HTH,
Dan
On 10/14/06, Ted Johnson <whatawonderfulworldweliveintoo@stripped> wrote:
>
> 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
> >
> >
> >
> >
> >
>
>
>
