shell学习之保存数据库

自动备份 Mysql 数据库脚本

#!/bin/bash
#author by wxp
#used to backup mysql practise

USER=root
PASSWD=1234
HOSTNAME=localhost
BACKUPFILE=backupfile1.sql
BACKUPDIR=/mysql/backup
if [ $USER != root ];then
        echo "must to be use root for exec shell"
        exit
fi

if [ ! -d $BACKUPDIR  ];then
        mkdir -p $BACKUPDIR
        echo "路径不存在，创建路径成功！$BACKUPDIR"
else
        echo "路径存在$BACKUPDIR"
fi

mysqldump -h$HOSTNAME -u$USER -p$PASSWD >$BACKUPDIR/$BACKUPFILE
chmod 755 $BACKUPDIR/$BACKUPFILE

 

学习模板

#!/bin/bash 
#auto backup mysql 
#wugk 2012-12-12 
#Define PATH 定义变量 
BAKDIR=/data/backup/mysql/`date +%Y-%m-%d` 
MYSQLDB=webapp 
MYSQLPW=backup 
MYSQLUSR=backup 
#must use root user run scripts 必须使用 root 用户运行， $UID 为系统变量
if [ $UID -ne 0 ];then
    echo This script must use the root user ! ! ! sleep 2 
    exit 0 
fi 
#Define DIR and mkdir DIR 判断目录是否存在，不存在则新建 
if [ ! -d $BAKDIR ];then 
    mkdir -p $BAKDIR else
    echo This is $BAKDIR exists....
fi
#Use mysqldump backup mysql 使用 mysqldump备份数据库
/usr/bin/mysqldump -u$MYSQLUSR -p$MYSQLPW -d$MYSQLDB>$BAKDIR/webapp_db.sql
echo "The mysql backup successfully"