backup mysql database and ftp to another computer
来源:互联网 发布:万方数据库免费 编辑:程序博客网 时间:2024/04/29 13:12
#!/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
# 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
- backup mysql database and ftp to another computer
- Transfer postgres database to another server - backup and restore
- MySQL Database backup and restore
- Backup and Restore MySQL Database Using mysqldump
- How to backup and restore database in SQL Server
- MySQL Backup and Restore Commands for Database Administration
- Oracle backup one table to another table.
- MySQL Backup and Restore
- How to Export and Import the AWR Repository From One Database to Another (文档 ID 785730.1)
- Step By Step Guide To Create Physical Standby Database Using RMAN Backup and Restore
- Copy database via backup and restore
- ALTER DATABASE BACKUP CONTROLFILE TO TRACE
- alter database backup controlfile to trace
- Transfer Statistics from one Database to Another
- backup database
- BACKUP DATABASE
- Step By Step Guide To Create Physical Standby Database Using RMAN Backup and Restore (Doc ID 469493.
- Set MySQL to use UTF-8 and convert database
- ONERASEBKGND OnPaint OnDraw
- 换工作记(三)------ 心再次被触动
- WEB 亿万用户 数据库解决方案
- sns
- 求两个整数的和
- backup mysql database and ftp to another computer
- Maven构建的生命周期
- IIS虚拟主机防木马权限安全配置整合
- 计算机行业励志故事
- FormatterEnums
- IIS虚拟主机防木马权限安全配置整合
- IIS虚拟主机防木马权限安全配置整合
- 电子政务或办公自动系统中动态电子表单的实现
- 介绍给大家学习Silverlight的网址!