做一个.sh脚本,其中有这么一句:cd /tmp/mysqlbackup
在shell命令行里面可以进去的,也赋予了755权限了。但是在执行sh的时候,到这句就报错了
: No such file or directory.sh: line 29: cd: /tmp/mysqlbackup
这是为什么呢,因为必须有这一句,后面会用到啊!
在shell命令行里面可以进去的,也赋予了755权限了。但是在执行sh的时候,到这句就报错了
: No such file or directory.sh: line 29: cd: /tmp/mysqlbackup
这是为什么呢,因为必须有这一句,后面会用到啊!
解决方案 »
- SQL中如何删除一个table
- MYSQL, 按照两列来分组的一条SQL ,求助
- 连接mysql报错:error2003(hy000:can't connect to mysql server on 'localhost'
- MySQL 远程自动备份
- 向mysql数据库插入数据异常
- 继续求sql
- 这样的sql怎么写
- 请教 mysql存储过程中 传递表名作参数怎么整啊?
- mysql 用phpmyadmin导入 数据库.zip文件 报错!求解答
- select查询为什么可以无限叠加,什么原理?
- 我在Windows下安装了MySQL5,数据库的储存路径在哪啊?
- 还是昨天的问题 由于没说清楚 今天贴出数据供大家测试
判断下这个目录存在不存在,然后再找原因
total 262312
-rw-r--r-- 1 root root 268330987 Dec 15 15:02 csf_20101215.sql
drwxr-xr-x 2 root root 4096 Dec 16 09:54 mysqlback
drwxr-xr-x 3 root root 4096 Dec 16 09:53 mysqlbackup
加完 if -d /tmp/mysqlbackup
之后呢,如何写啊?可以给个简单的例子吗?
chmod: invalid mode: `+777'
Try `chmod --help' for more information.报错啊!
# Name: mysqlFullBackup.sh
# PS:MySQL DataBase Full Backup.
# Write by: skyman
# Last Modify:2010-12-15
#
# Use mysqldump --help get more detail.
#
#
#
scriptsDir=/usr/script# define data directy
mysqlDir=/usr/local/mysql
# defile user,pwd
user=root
userPWD=123456
#
dataBackupDir=/tmp/mysqlbackup
eMailFile=$dataBackupDir/email.txt# email
[email protected]
[email protected]# backup file
logFile=$dataBackupDir/mysqlbackup.log
DATE=`date -I`echo "" > $eMailFile
echo $(date +"%y-%m-%d %H:%M:%S") >> $eMailFile
cd $dataBackupDir# defile filename
dumpFile=mysql_$DATE.sql
GZDumpFile=mysql_$DATE.sql.tar.gz
# use mysqldump, set params
$mysqlDir/bin/mysqldump -u$user -p$userPWD \
--opt --default-character-set=utf8 --extended-insert=false \
--triggers -R --hex-blob --all-databases \
--flush-logs --delete-master-logs \
--delete-master-logs \
-x > $dumpFile
# zip backup file
if [[ $? == 0 ]]; then tar czf $GZDumpFile $dumpFile >> $eMailFile 2>&1 echo "BackupFileName:$GZDumpFile" >> $eMailFile echo "DataBase Backup Success!" >> $eMailFile rm -f $dumpFile
# Delete daily backup files. cd $dataBackupDir/daily rm -f *
# Delete old backup files(mtime>2). $scriptsDir/rmBackup.sh
# Move Backup to anthor machine# Move Backup Files To Backup Server Start.
#
# $scriptsDir/rsyncBackup.sh
# if (( !$? )); then
# echo "Move Backup Files To Backup Server Success!" >> $eMailFile
# else
# echo "Move Backup Files To Backup Server Fail!" >> $eMailFile
# fi
# Move Backup Files To Backup Server Stop.else echo "DataBase Backup Fail!" >> $emailFilefi# write log fileecho "--------------------------------------------------------" >> $logFilecat $eMailFile >> $logFile# send emailcat $eMailFile | mail -s "MySQL Backup" $eMail
cat $eMailFile | mail -s "MySQL Backup" $eMail2
然后再执行你的脚本试试