红联Linux门户
Linux帮助

MySQL数据自动备份并且ftp的shell文件

发布时间:2005-10-22 17:30:02来源:红联作者:linux2006
这个是我写的第一个shell文件,请大家多多指教

MySQLbackup.sh 是备份整个MySQL数据库的数据
[code:1:c4b67eae16]#!/bin/bash

############### MySQL Backup & FTP ################
#Power By SBear 2004-01-20 2:10
#E-mail:sbear_ji@126.com
#http://www.1842.net
#http://www.CnLinux.net

#1. mkdir /home/backup
#2. chmod 700 MySQLbackup.sh
#3. vi /etc/crontab , 30 03 * * * root /home/backup/MySQLbackup.sh
#everyday 03:30 the MySQLbackup.sh will work

#System Setup
host=192.168.0.3 #ftp host
UserName=ftp #ftp user name
Passwd=ftp #fto user password

backup_path=/home/backup #set saved backup path
file=mysql-$(date +%Y%m%d).tar.gz
backupCWD=/usr/local/mysql/var #set backup file,the mysql database

#stop mysql database server
/usr/bin/killall mysqld
#/etc/rc.c/init.d/mysqld stop

sleep 5s #stop 5 second

#file tar
tar -czf $backup_path/$file $backupCWD

sleep 10s

#start mysql database server
/usr/local/mysql/bin/mysqld_safe --user=mysql & #set your mysqld path
#/etc/rc.d/init.d/mysqld start

cd $backup_path
sleep 1s
#file ftp
ftp -i -n <open $host
user $UserName $Passwd
put $file
bye
!

sleep 10s
rm -rf $backup_path/$file[/code:1:c4b67eae16]


DBbackup.sh 是备份单个数据库的数据
[code:1:c4b67eae16]#!/bin/bash

############### MySQL One DataBase's Backup & FTP ################
#Power By SBear 2004-01-20 2:40
#E-mail:sbear_ji@126.com
#http://www.1842.net
#http://www.CnLinux.net

#1. mkdir /home/backup
#2. chmod 700 DBbackup.sh
#3. vi /etc/crontab , 30 03 * * * root /home/backup/DBbackup.sh
#everyday 03:30 the DBbackup.sh will work

#System Setup

#ftp Info
host=192.168.0.3 #ftp host
UserName=ftp #ftp user name
Passwd=ftp #fto user password

#MySQL Info
SQL_host=localhost #MySQL host
SQL_User=root #MySQL UserName
SQL_Passwd=abc #User Password
SQL_db=test #database name


backup_path=/home/backup #set saved backup path
file=$SQL_db-$(date +%Y%m%d).tar.gz
MySQL_path=/usr/local/mysql/bin #set the mysql database bin path

cd $backup_path
#export database
$MySQL_path/mysqldump -h $SQL_host -u$SQL_User -p$SQL_Passwd --databases $SQL_db>$SQL_db.dump

sleep 5s
#file tar
tar -czf $backup_path/$file $SQL_db.dump

sleep 10s

cd $backup_path
sleep 1s
#file ftp
ftp -i -n <open $host
user $UserName $Passwd
put $file
bye
!

sleep 10s
rm -rf $backup_path/$file
rm -rf $backup_path/$SQL_db.dump
[/code:1:c4b67eae16]
文章评论

共有 1 条评论

  1. win-linux 于 2005-10-28 00:25:28发表:

    支持