struggling with a one liner

I did try that, however, (and I should have been more clear
in my request) I was wondering how to do it without writing
to a temp file; to some how pipe stdout to mpack.


On Wed, Sep 04, 2002 at 08:38:40AM -0700, Colin Ansel Rasor wrote:
Mike,

This is with MIME. Outlook Express will line wrap this I am sure so look at
quotes.

"mysqldump -B test -p > test.sql; mpack -s test.sql -d test.sql -c
application/html test.sql $emailaddress"

First we dump the file we need, it writes it self to test.sql then we mpack
it and send it where it needs to go. The next time the one liner runs it
will automatically overwrite the file that was last created if it exists. It
might be a good idea to use /tmp for output but that is your preference.

--Colin

----- Original Message -----
From: "Mike Starke" <meg@lilly.csoft.net>
To: "Colin Rasor" <ansel@millworknet.com>
Sent: Wednesday, September 04, 2002 7:11 AM
Subject: Re: struggling with a one liner


> Yea, I know............ I need to use mpack
>
> On Tue, Sep 03, 2002 at 09:55:03PM -0700, Colin Rasor wrote:
> Mike,
>
> This doesn¹t include MIME but it might get you started.
>
>
> $database = your database
> $emailaddress = your dump email
>
>
> mysqldump -B $database | mail $emailaddress
>
>
> On 9/3/02 20:39, "Mike Starke" <meg@lilly.csoft.net> wrote:
>
> > Maybe I'm tired, or maybe ...? Anyhow, I would
> > like to come up with a one-liner to run mysqldump
> > on a database, then mpack the output to a given email address.
> >
> > Anyone?
> >
> > v/r
> > Mike
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> > To subscribe, unsubscribe, or to change you mail settings:
> > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
> >
> >
> >
> I
>
>
>
>
>
>