我用猫版的自动备份脚本出现这样的错误提示，是怎么回事

fhzart

今天用猫版的vps自动备份，测试出现这样的提示。
麻烦帮我看看吧。我安装的是centos+webmin
红色是出错的部分。

[root@li340-26 home]# ./AutoBackupToFtp.sh
./AutoBackupToFtp.sh: line 24: /usr/local/mysql/bin/mysql: No such file or directory
tar: Removing leading `/' from member names
tar: /home/backup/*.sql.gz: Cannot stat: No such file or directory
tar: Error exit delayed from previous errors
Connected to 97.74.144.193 (97.74.144.193).
220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------
220-You are user number 2 of 75 allowed.
220-Local time is now 20:16. Server port: 21.
220-This is a private system - No anonymous login
220 You will be disconnected after 3 minutes of inactivity.
Remote system type is UNIX.
Using binary mode to transfer files.
331 User poke8001 OK. Password required
230-User poke8001 has group access to:  450
230 OK. Current directory is /
200 TYPE is now 8-bit binary
250 OK. Current directory is /backup
550 Could not delete Data_20110727.tar.gz: No such file or directory
550 Could not delete Web_20110727.tar.gz: No such file or directory
local: Data_20110801.tar.gz remote: Data_20110801.tar.gz
227 Entering Passive Mode (97,74,144,193,197,105)
150 Accepted data connection
226-File successfully transferred
226 0.039 seconds (measured here), 1.14 Kbytes per second
45 bytes sent in 7.4e-05 secs (5.9e+02 Kbytes/sec)
local: Web_20110801.tar.gz remote: Web_20110801.tar.gz
local: Web_20110801.tar.gz: No such file or directory
221-Goodbye. You uploaded 1 and downloaded 0 kbytes.
221 Logout.

[ 本帖最后由 fhzart 于 2011-8-2 11:32 编辑 ]

cnweb

哥  你发重复了

堕落kiss

whereis mysql 把得到的路径改在你脚本里，改完第一个错误，第二个应该就没了

fhzart

原帖由 cnweb 于 2011-8-2 11:32 发表
哥  你发重复了

谢谢，已经删除了多发的。

fhzart

#导出数据库,一个数据库一个压缩文件
for db in `/usr/local/mysql/bin/mysql -u$MYSQL_USER -p$MYSQL_PASS -B -N -e 'SHOW DATABASES' | xargs`; do
    (/usr/local/mysql/bin/mysqldump -u$MYSQL_USER -p$MYSQL_PASS ${db} | gzip -9 - > ${db}.sql.gz)


是不是这句的问题，我应该怎么改呢？

qiqi13245

find / -name mysql
找到替换路径

skywing

提示得很清楚了，没有那个文件，把路径改下

fhzart

原帖由 qiqi13245 于 2011-8-2 13:57 发表
find / -name mysql
找到替换路径

这是查找结果

1. 
   
2. [root@li340-26 ~]# find / -name mysql
   
3. /etc/usermin/mysql
   
4. /etc/webmin/mysql
   
5. /var/lib/mysql
   
6. /var/lib/mysql/mysql
   
7. /usr/include/mysql
   
8. /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBD/mysql
   
9. /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql
   
10. /usr/lib/mysql
    
11. /usr/share/mysql
    
12. /usr/libexec/usermin/mysql
    
13. /usr/libexec/usermin/virtual-server-theme/mysql
    
14. /usr/libexec/usermin/caldera/mysql
    
15. /usr/libexec/usermin/blue-theme/mysql
    
16. /usr/libexec/webmin/mysql
    
17. /usr/libexec/webmin/virtual-server-theme/mysql
    
18. /usr/libexec/webmin/caldera/mysql
    
19. /usr/libexec/webmin/mscstyle3/mysql
    
20. /usr/libexec/webmin/blue-theme/mysql
    
21. /usr/bin/mysql
    
22. 
    

复制代码

我现在改成了这样，麻烦看看对吗？ 谢谢了

1. #导出数据库,一个数据库一个压缩文件
   
2. for db in `/usr/bin/mysql -u$MYSQL_USER -p$MYSQL_PASS -B -N -e 'SHOW DATABASES' | xargs`; do
   
3.     (/usr/bin/mysqldump -u$MYSQL_USER -p$MYSQL_PASS ${db} | gzip -9 - > ${db}.sql.gz)
   
4. 
   

复制代码