backup mysql database and ftp to another computer

最新推荐文章于 2024-12-17 16:31:00 发布

book2016

最新推荐文章于 2024-12-17 16:31:00 发布

阅读量730

点赞数

CC 4.0 BY-SA版权

分类专栏： shell 文章标签： mysql database date disk user

本文链接：https://blog.youkuaiyun.com/zzz_781111/article/details/3123775

shell 专栏收录该内容

22 篇文章

订阅专栏

本文提供了一个使用shell脚本实现MySQL数据库备份的示例。该脚本通过mysqldump工具导出数据库到指定目录，并记录操作日志。备份完成后，会压缩文件并通过FTP上传到远程服务器。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

#!/bin/sh
# mysql data backup by Jason
# by scud http://www.lcshow.com
# 2008-01-23
#
# use mysqldump
#
BakDir=/backup/mysql
LogFile=/backup/mysql/mysqlbak.log
DATE=`date +%Y%m%d`
echo " " >> $LogFile
echo " " >> $LogFile
echo "-------------------------------------------" >> $LogFile
echo $(date +"%y-%m-%d %H:%M:%S") >> $LogFile
echo "--------------------------" >> $LogFile
cd $BakDir
DumpFile=$DATE.sql
GZDumpFile=$DATE.sql.tgz
mysqldump -uroot -p'mymysqlpassword' mydbname > $DumpFile
echo "Dump Done" >> $LogFile
tar czvf $GZDumpFile $DumpFile >> $LogFile 2>&1
echo "[$GZDumpFile]Backup Success!" >> $LogFile
rm -f $DumpFile
cd $BakDir/daily
rm -f *
cd $BakDir
echo "Backup Done!"
echo "please Check $BakDir Directory!"
echo "copy it to your local disk or ftp to somewhere !!!"
ftp -n<<!

open 222.222.333.22

user myusername mypassword

binary

cd /mysql_backup

lcd $BakDir

prompt

put $GZDumpFile

close

bye

!
ls -al $BakDir >> $LogFile
echo "-----------------close----------" >> $LogFile
echo $(date +"%y-%m-%d %H:%M:%S") >> $LogFile
echo "----------------------close----" >> $LogFile