Filename zip stdin

Athas · 10-22-2005, 06:03 AM

I've been trying to get a shell script working that would mail me a database backup but I can't seem to get it working correctly the problem is that the filename for the sql file is - which I cant use through the cli as it thinks that I'm trying to use stdin instead of a filename

Code:

#!
mysqldump -u root -ppassword databasename  |zip backup.zip -
uuencode backup.zip backupzip.zip | mail fake@example.com -s"Database backup"

I'd like the filename within the zip to be something like backup-22-09-05.sql Is this possible?
I'd also like to insert the date in the email subject if possible.

Thanks,
Wesley

MensaWater · 10-22-2005, 06:22 PM

This seems a little confused.

I'll ignore your code which makes it appear you ARE using "-" for stdin and just answer what you wrote about the file name being "-".

If you really need to name it "-" then you can escape the special meaning of "-" by typing "\-" instead of just "-".

eddiebaby1023 · 10-23-2005, 09:56 AM

Here's a snippet from mine, which does what yours is trying to do, in a slightly different way:

Code:

EMAILTO="me@mydomain.com"
MYSQL=$(/usr/bin/which mysqldump 2>/dev/null)
dumpdate=$(date "+%Y%m%d%H%M")
if $MYSQL -u username -ppassword databasename > $HOME/backups/$dumpdate.backup
then
    echo "Database backed up to $dumpdate.backup"
    # cpio the archive and email it to the recipient list
    cd $HOME/backups
    echo $dumpdate.backup | /bin/cpio -o | uuencode $dumpdate.backup |
                                /bin/mail -n -s "$dumpdate Archive" $EMAILTO
else
    echo "Database not backed up"
    [ -f $HOME/backups/$dumpdate.backup ] && rm $HOME/backups/$dumpdate.backup
    exit 1
fi

Athas · 10-23-2005, 01:30 PM

Thanks very much this looks useful,
since my original post I tried to do this a different way. However much to my disgust I've realised that uuencode isn't on my web-server. Is there any other way to send an attachment through the CLI?

For reference here is the code that I'm currently using, in case anyone else finds it useful

Code:

#!/bin/csh
set todaysDate=`date +%a_%d_%b_%y`
mysqldump -u username -ppassword dbName > dbName_${todaysDate}.sql
zip backup backupname${todaysDate}.sql
uuencode backup.zip backupname${todaysDate}.zip | mail test@example.com -s"Database backup ${todaysDate}"
rm backupname${todaysDate}.sql
rm backup.zip

Thanks,
Regards,
Wesley

Athas · 10-29-2005, 04:56 AM

The webserver didn't have uuencode installed but they did have mutt installed.

Theres a good article on sending email attachments
http://www.shelldorado.com/articles/...tachments.html