shell数据库备份

shell数据库备份

 

花了点时间，学了下shell

 

弄个数据库备份。

01

1 #!bin/sbin

02

2

03

3 cd /home/igeeker/IDE/myeclipse/workspace/outdoors/WebRoot

04

4 echo "back directory"

05

5 # sql文件存在，则删除

06

6 if [ -f *.sql ];then

07

7 rm *.sql

08

8 fi

09

9

10

10 Now=$(date +"%d%m%Y")

11

11 File=backup$Now.sql

12

12 mysqldump -u root -pwangtong outdoors > $File

13

13 echo "backup done ! "