Shulou(Shulou.com)06/01 Report--

#! / bin/bash

# author:zwy

# 2016-12-15

# auto backup db ypsh

Dt= `date "+% Y_%m_%d" `

Prefix= "ypsh_"

Suffix='.sql'

Xname=$ {prefix} ${dt} ${suffix}

Echo $xname

Mysql_dir= "/ usr/local/mysql/bin/"

Db_bak_dir= "/ root/ypsh_db_bak/"

Cd $mysql_dir

Echo `pwd`

. / mysqldump-hlocalhost-uroot-pabcedf. Ypsh > / root/ypsh_db_bak/$xname

Cd $db_bak_dir

Echo `pwd`

Tar_xname=$ {xname} ".tar.gz"

Echo $tar_xname

Tar-zcvf $tar_xname $xname

Ip= "172.29.0.182"

User= "zwf_2016"

Passwd= "abcedf9527"

Lftp open $ip-u $user,$passwd

Put $tar_xname

Close

Bye

!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.