全球主机交流论坛

标题: 我用猫版的自动备份脚本出现这样的错误提示，是怎么回事 [打印本页]

作者: fhzart 时间: 2011-8-2 11:31
标题: 我用猫版的自动备份脚本出现这样的错误提示，是怎么回事
今天用猫版的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 时间: 2011-8-2 11:32
哥你发重复了

作者: 堕落kiss 时间: 2011-8-2 11:35
whereis mysql 把得到的路径改在你脚本里，改完第一个错误，第二个应该就没了

作者: fhzart 时间: 2011-8-2 11:35

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

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

作者: fhzart 时间: 2011-8-2 13:55
#导出数据库,一个数据库一个压缩文件
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 时间: 2011-8-2 13:57
find / -name mysql
找到替换路径

作者: skywing 时间: 2011-8-2 14:00
提示得很清楚了，没有那个文件，把路径改下

作者: fhzart 时间: 2011-8-2 14:05

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

这是查找结果

[root@li340-26 ~]# find / -name mysql
/etc/usermin/mysql
/etc/webmin/mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/include/mysql
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBD/mysql
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql
/usr/lib/mysql
/usr/share/mysql
/usr/libexec/usermin/mysql
/usr/libexec/usermin/virtual-server-theme/mysql
/usr/libexec/usermin/caldera/mysql
/usr/libexec/usermin/blue-theme/mysql
/usr/libexec/webmin/mysql
/usr/libexec/webmin/virtual-server-theme/mysql
/usr/libexec/webmin/caldera/mysql
/usr/libexec/webmin/mscstyle3/mysql
/usr/libexec/webmin/blue-theme/mysql
/usr/bin/mysql

复制代码

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

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

复制代码

欢迎光临全球主机交流论坛 (https://443502.xyz/)