军哥，还要麻烦一下，关于备份的问题

mrtaurus

我看了你的备份数据库到FTP的，成功了。我的情况是这样的，我还有一个虚拟主机，我想做个备用的地址，他在FTP空间提供了一个数据库恢复目录。我想每天把VPS上/usr/local/mysql/var/数据库名/里面的数据库文件（就是后缀FRM MYD的文件）拷贝到backup目录，不要压缩。然后利用fFTP将这个目录里面的文件远程备份到FTPSQL恢复目录里面。这样我只需要点一下空间里的恢复数据库就同步了。拷贝过程中有相同文件直接覆盖，请问这样怎么实现？菜鸟一个，帮帮我忙吧，谢谢啦。

你文件中的backup.sh内容，求修改

1. #!/bin/bash
   
2. 
   
3. #Funciont: Backup website and mysql database
   
4. #Author: licess
   
5. #Website: http://lnmp.org
   
6. 
   
7. #IMPORTANT!!!Please Setting the following Values!
   
8. 
   
9. Backup_Home="/home/backup/"
   
10. MySQL_Dump="/usr/local/mysql/bin/mysqldump"
    
11. ######~Set Directory you want to backup~######
    
12. Backup_Dir=("/home/wwwroot/vpser.net" "/home/wwwroot/lnmp.org")
    
13. 
    
14. ######~Set MySQL Database you want to backup~######
    
15. Backup_Database=("lnmp" "vpser")
    
16. 
    
17. ######~Set MySQL UserName and password~######
    
18. MYSQL_UserName='root'
    
19. MYSQL_PassWord='yourrootpassword'
    
20. 
    
21. ######~Enable Ftp Backup~######
    
22. Enable_FTP=0
    
23. # 0: enable; 1: disable
    
24. ######~Set FTP Information~######
    
25. FTP_Host='1.2.3.4'
    
26. FTP_Username='vpser.net'
    
27. FTP_Password='yourftppassword'
    
28. FTP_Dir="backup"
    
29. 
    
30. #Values Setting END!
    
31. 
    
32. TodayWWWBackup=www-*-$(date +"%Y%m%d").tar.gz
    
33. TodayDBBackup=db-*-$(date +"%Y%m%d").sql
    
34. OldWWWBackup=www-*-$(date -d -3day +"%Y%m%d").tar.gz
    
35. OldDBBackup=db-*-$(date -d -3day +"%Y%m%d").sql
    
36. 
    
37. Backup_Dir()
    
38. {
    
39.     Backup_Path=$1
    
40.     Dir_Name=`echo ${Backup_Path##*/}`
    
41.     Pre_Dir=`echo ${Backup_Path}|sed 's/'${Dir_Name}'//g'`
    
42.     tar zcf ${Backup_Home}www-${Dir_Name}-$(date +"%Y%m%d").tar.gz -C ${Pre_Dir} ${Dir_Name}
    
43. }
    
44. Backup_Sql()
    
45. {
    
46.     ${MySQL_Dump} -u$MYSQL_UserName -p$MYSQL_PassWord $1 > ${Backup_Home}db-$1-$(date +"%Y%m%d").sql
    
47. }
    
48. 
    
49. if [ ! -f ${MySQL_Dump} ]; then  
    
50.     echo "mysqldump command not found.please check your setting."
    
51.     exit 1
    
52. fi
    
53. 
    
54. if [ ! -d ${Backup_Home} ]; then  
    
55.     mkdir -p ${Backup_Home}
    
56. fi
    
57. 
    
58. type lftp >/dev/null 2>&1 || { echo >&2 "lftp command not found. Install: centos:yum install lftp,debian/ubuntu:apt-get install lftp."; }
    
59. 
    
60. echo "Backup website files..."
    
61. for dd in ${Backup_Dir[@]};do
    
62.     Backup_Dir ${dd}
    
63. done
    
64. 
    
65. echo "Backup Databases..."
    
66. for db in ${Backup_Database[@]};do
    
67.     Backup_Sql ${db}
    
68. done
    
69. 
    
70. echo "Delete old backup files..."
    
71. rm -f ${Backup_Home}${OldWWWBackup}
    
72. rm -f ${Backup_Home}${OldDBBackup}
    
73. 
    
74. if [ ${Enable_FTP} = 0 ]; then
    
75.     echo "Uploading backup files to ftp..."
    
76.     cd ${Backup_Home}
    
77.     lftp ${FTP_Host} -u ${FTP_Username},${FTP_Password} << EOF
    
78. cd ${FTP_Dir}
    
79. mrm ${OldWWWBackup}
    
80. mrm ${OldDBBackup}
    
81. mput ${TodayWWWBackup}
    
82. mput ${TodayDBBackup}
    
83. bye
    
84. EOF
    
85. 
    
86. echo "complete."
    
87. fi

复制代码

licess

bye 前面加上一句 mirror -R /usr/local/mysql/var/数据库名  这个数据库名就会备份到ftp上

mrtaurus

好的，修改成功了，谢谢