服务器备份mysql

#!/bin/bash

currentpath=/home/sqlbackup

backpath="newf6232eeling"

 

function makedir(){

echo $(date "+%Y-%m-%d %H:%M:%S")

if [ -d $currentpath/$(date +%y%m%d) ]; then

echo "$(date +%y%m%d) is exsit"

else

mkdir $currentpath/$(date +%y%m%d)

echo "$(date +%y%m%d) is building"

fi

}

 

function backupsql(){

bakckpath=$currentpath/$(date +%y%m%d)

for i in $backpath;

do

backuptime=$(date +%y%m%d%H%M)

mysqldump -uroot -py37fdbsdfs456! $i>$bakckpath/$backuptime$i.sql

done

}

 

makedir

backupsql