DB backup script.sh

#!/bin/bash
# set chmod 700 to /backup for security reasons 
cd /backup
FILENAME=`date +%d%b%Y`-mysql_alldb.tar.gz.sec
mysqldump --single-transaction -u backup -pmysqlpasswd --all-databases > backup.sql
tar -cf - backup.sql | gzip -c > backup.tar.gz
openssl des -in backup.tar.gz -out $FILENAME -pass pass:cryptpasswd
scp $FILENAME backup@backupsvr:/backup/srv1/db
echo `md5sum $FILENAME` >> md5sum.log
rm backup.sql backup.tar.gz $FILENAME


MYSQL on Slackware

# cp /etc/my-medium.cnf /etc/my.cnf
# chown -R mysql.mysql /var/lib/mysql
# /usr/bin/mysql_install_db
# cd /var/lib
# chown -R mysql:mysql mysql
# /usr/bin/mysqladmin -u root password 'new-passwd'


# chmod +x /etc/rc.d/rc.mysqld
#/etc/rc.d/rc.mysqld start