Here is the bourne shell script on my Centos unix Hostgator shared hosting server placed in the crontab and runs once in a day at 3am my country time.
#!/bin/sh
cd /home/myname/www/tmp/all
mv *.sql j
rm *.gz
for i in *dump*.sh
do
if ! sh $i
then
echo "Failed for $i"
exit
else
echo "$i success"
fi
done
d=`date|tr " :" --`
echo $d
ls -l *.sql
echo "Total files=" `ls -l *.sql|wc -l`
file="scripts.tar"
if ! tar cvf $file *.sh *.php
then
echo "tar for file:$file has failed"
exit
fi
if ! gzip -9 $file
then
echo "gzip for file:$file has failed"
exit
fi
echo "...........................Success .... see the file below:"
ls -lh "$file.gz"
for i in *.sql
do
if ! gzip -9 $i
then
echo "gzip for file:$i failed"
exit 1
fi
done
echo "Emailing it"
for i in *.gz
do
if ! php email.php "$i"
then
echo "Email failed for $i"
fi
done
echo "Email sent successfully"
exit 0
-----------------------------------------------
Content on my sample mysqldump_adi.sh
mysqldump -h localhost -u <dblogin> <dbname> -p<dbpasswd> outfile.sql
-------------------------------------------
Email.php: Here is the source code to send files by attachment using Smtp in Php.
