网上找来的MYSQL备份脚本.我没看明白,谁能给解释下,谢谢!

kele@live.it

1. #!/bin/sh
   
2. #
   
3. # Created by david yeung.
   
4. #
   
5. # 20080707.
   
6. #
   
7. # Backup mysql's full data.
   
8. #
   
9. DBNAME=$1
   
10. BACKUPDIR="/data/backup"
    
11. USERNAME=root
    
12. PASSWD=520qq
    
13. BIN_DIR="/usr/bin"
    
14. TARNAME="$BACKUPDIR"/backup"$1"`date +"%Y-%m-%d"`
    
15. # Add your own database name here.
    
16. case "$1" in
    
17.   my_site);;
    
18.   *) exit;;
    
19. esac
    
20. # Get all the tables name.
    
21. NUM=`$BIN_DIR/mysql -u$USERNAME -p$PASSWD -s -vv -e "show tables" -D $DBNAMEwc -l`
    
22. HEADNUM=`expr ${NUM} - 3`
    
23. TAILNUM=`expr ${NUM} - 7`
    
24. ARR1=`$BIN_DIR/mysql -u$USERNAME -p$PASSWD -s -vv -e "show tables" -D $DBNAME head -n"$HEADNUM" tail -n "$TAILNUM"`
    
25. ARR2=($ARR1)
    
26. i=0
    
27. while [ "$i" -lt "${#ARR2[@]}" ]
    
28. do
    
29. tmpFileName=${ARR2[$i]}
    
30. # The real dump process.
    
31. $BIN_DIR/mysqldump -u$USERNAME -p"$PASSWD" "$DBNAME" "$tmpFileName" >> "$TARNAME"
    
32. let "i++"
    
33. done

复制代码

从# Get all the tables name.
到最后.谢谢啊.........

kele@live.it

郁闷,自己测试了一下,似乎只能备份一个数据库啊.

vepeta

这个脚本本来就是按照数据库名称来备份的 每次只能备份一个库

ruochen

DBNAME=$1

squall1

mysqlhotcopy备份多个数据库脚本
mysqldump备份多个数据库脚本

http://blog.linuxhomes.cn/archives/89/