mysql backup script

script

dirname=`date +%Y-%m-%d_%H-%M`
[ -z $dirname ] && (echo "目录存在";echo 1) || (echo "目录不存在";echo 2;mkdir $dirname)

for name in `echo cacti jacky`
do
    echo $name
    mysqldump -h somehost -u someuser -psomepassword $name > $dirname/$name.sql
done