mysqldump –opt -Q -u dbusername –password=dbpassword dbname > /pathto/backups/`date +%A`.sql

mysqldump -opt -Q -uusername -ppassword db_name | gzip > /path/to/backups/`date +%A`.gz

mysqldump -Q -uuser_name -ppassword db_name | gzip > /path/to/backup/`date +%A`.gz && mutt -s "`date +%A`'s backup" -a /path/to/backup/`date +%A`.gz someone@nowhere.com < /dev/null

#!/bin/bash

cd /home/mydomain/backup

# Database Settings
DATABASES='database1 database2 database3'
DATABASE_PREFIX='mysite_'
DATABASE_USER='mysite_username'
DATABASE_PASS='mypassword'

# FTP Settings
FTP_HOST='myserver.com'
FTP_USER='backup_user'
FTP_PASS='backup_password'
FTP_PATH='/'

# Backup entire home directory
TIMESTAMP=`date +%F-%H-%M`
tar -czf ${TIMESTAMP}_files.tar.gz --exclude ../backup --exclude ../www ../

# Backup databases
for database in ${DATABASES}
do
    mysqldump -u ${DATABASE_USER} --password=${DATABASE_PASS} --opt -Q ${DATABASE_PREFIX}${database} > ${TIMESTAMP}_${database}.sql && gzip --best ${TIMESTAMP}_${database}.sql
done

# Combine the backup
tar -cf ${TIMESTAMP}.tar *.gz

# Remove all by the final tar
rm *.gz

# Upload the backup
ftp -i -n ${FTP_HOST} << EOF
user ${FTP_USER} ${FTP_PASS}

binary
passive
cd ${FTP_PATH}
put ${TIMESTAMP}.tar

quit
EOF

# Remove the remaining tar
rm *.tar

exit 0

~/public_html/backups

/home/USERNAME/public_html/backups

tar -czf /home/USERNAME/backups/`date +\%F`.tar.gz /home/USERNAME/public_html

mysqldump -opt -Q -uMYSQLUSER -pMYSQLPASSWD MYSQLDB | gzip > /home/USERNAME/backups/logs/`date +\%F`.gz

#!/bin/sh

# Database Settings
DATABASES='list_of_all_mysql_dbs'
DATABASE_PREFIX='xxx_'
DATABASE_USER='xxx_backup'
DATABASE_PASS='some_password'

# Backup site settings
FTP_SITE='ftp.xxx.yyy'
FTP_USER='xxxx'
FTP_PASS='xxxxx'

echo `date` Backup processing started

if [[ ! -e ~/backup ]]; then
    echo
    echo `date` Backup destination does not exist. Creating it
    mkdir ~/backup
elif [[ ! -d ~/backup ]]; then
    echo
    echo `date` Backup destination exists \; however it is not a directory
    echo `date` Exiting now
    exit 1
fi

cd ~/backup

# Backup entire home directory
TIMESTAMP=`date +%F-%H-%M`
echo
echo `date` Backing up Web root directory
tar -czf ${TIMESTAMP}_files.tar.gz ../public_html

# Backup databases
for database in ${DATABASES}
do
    echo
    echo `date` Dumping database: ${DATABASE_PREFIX}${database}
    mysqldump -u ${DATABASE_USER} --password=${DATABASE_PASS} --opt -Q ${DATABASE_PREFIX}${database} > ${TIMESTAMP}_${database}.sql && gzip --best ${TIMESTAMP}_${database}.sql
done

# Combine the backup
echo
echo `date` Creating tar file: ${TIMESTAMP}.tar
tar -cf ${TIMESTAMP}.tar ${TIMESTAMP}*.gz

# Remove the original files
echo
echo `date` Removing input files
rm -v ${TIMESTAMP}*.gz

# Removing old backups
echo
echo `date` Removing old backups
OLD_FILES=`find . -mtime +7 -print`
for filename in ${OLD_FILES}; do
    echo `date` Removing ${filename}
    rm ${filename}
done

# Build FTP command's
echo
echo `date` Building FTP script
TMP_FILE='my_cmds.$($}'
echo user ${FTP_USER} ${FTP_PASS} > ${TMP_FILE}
echo binary >> ${TMP_FILE}
echo passive >> ${TMP_FILE}
echo put ${TIMESTAMP}.tar >> ${TMP_FILE}
for filename in ${OLD_FILES}; do
    echo delete ${filename} >> ${TMP_FILE}
done
echo quit >> ${TMP_FILE}

# Sending backup offsite
echo
echo `date` Sending backups offsite
ftp -i -n ${FTP_SITE} < ${TMP_FILE}

# Removing command file
echo
echo `date` Removing FTP command file
rm ${TMP_FILE}

# all done
echo
echo `date` Backup processing completed

exit 0

#!/bin/sh
date=`date +%y%j%H%M%S`
mysqldump -uuser -ppassword user_$1 | gzip -c > /home/user/mysql/$date.$1.sql.bz2

/home/name/complete.sh: line 1: #!/bin: No such file or directory
tar: Removing leading `..' from member names
tar: ..: Cannot open: Permission denied
tar: Error exit delayed from previous errors
Passive mode off.

#!/bin/sh
# change this to your cPanel user name
user="username"
# change this to your cPanel password
password="password"
# change the date string if you want
date=`date +%y%j%H%M%S`
mysqldump -u$user -p$password "$user"_$1 | gzip -c > ~/mysql/$1.$date.sql.gz

theviper@server1 [~]# sh backups
: command not found
: command not found
: command not found
Fri Jan 2 01:14:44 EST 2009 Backup processing started
: command not found
backups: line 20: syntax error near unexpected token `elif'
'ackups: line 20: `elif [[ ! -d ~/backup ]]; then

#!/bin/sh
USERNAME="***"
PASSWORD="***"
SERVER="***"

# login to remote server
ftp -n $SERVER <<EOF
user $USERNAME $PASSWORD
mput $SOM_FILE/*.tar.gz
quit

#!/bin/sh
USERNAME="???"
PASSWORD="???"
SERVER="???"

ftp -n $SERVER <<EOF
user $USERNAME $PASSWORD
put ~/molokai/test.txt
quit

#!/bin/sh
DATE=` date +%A  | tr "[:upper:]" "[:lower:]" `


mysqldump --opt -Q -u DATABASE_USER --password=DATABASE_PASS DATABASE  | gzip > ~/BACKUP_FOLDER/$DATE.sql.gz

scp ~/BACKUP_FOLDER/$DATE.sql.gz SOME_DISTANT_SERVER:~/DISTANT_BACKUP_FOLDER