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
 >
 >
 >
 >
 >
 >