Wrote a MySQL backup script, everybody look, what's wrong with the place.
This is the first shell script I wrote, let's see,
I can send it to someone who needs it.
You can put this script in crontab, do it every morning, and automatically back up
This script executes at most one time per day and retains only the last five days of backup on the server.
Code:
[Code]
#!/bin/bash
#This is a shellscript for Auto DB Backup
#Powered by Aspbiz
#2004-09
#Setting
#设置数据库名, database login name, password, backup path, log path, data file location, and backup mode
#默认情况下备份方式是tar, it could be mysqldump,mysqldotcopy.
#默认情况下, log in to the MySQL database with root (empty) and back up to/root/dbxxxxx.tgz
Dbname=mysql
Dbuser=root
Dbpasswd=
backuppath=/root/
Logfile=/root/db.log
dbpath=/var/lib/mysql/
#BackupMethod =mysqldump
#BackupMethod =mysqlhotcopy
#BackupMethod =tar
#Setting End
Newfile= "$BackupPath" db$ (date +%y%m%d). tgz
Dumpfile= "$BackupPath" db$ (date +%y%m%d)
Oldfile= "$BackupPath" db$ (date +%y%m%d--date= ' 5 days ago '). tgz
echo "-------------------------------------------" >> $LogFile
echo $ (date + "%y-%m-%d%h:%m:%s") >> $LogFile
echo "--------------------------" >> $LogFile
#Delete Old File
If [-F $OldFile]
Then
Rm-f $OldFile >> $LogFile 2>&1
echo "[$OldFile]delete old File success!" >> $LogFile
Else
echo "[$OldFile]no old Backup file! >> $LogFile
Fi
If [-F $NewFile]
Then
echo "[$NewFile]the Backup File is Exists,can ' t backup!" >> $LogFile
Else
Case $BackupMethod in
Mysqldump
If [-Z $DBPasswd]
Then
Mysqldump-u $DBUser--opt $DBName > $DumpFile
http://www.bkjia.com/PHPjc/631865.html www.bkjia.com true http://www.bkjia.com/PHPjc/631865.html techarticle wrote a MySQL backup script, everybody look, what's wrong with the place. This is the first shell script I wrote, everyone help to see, who needs, I can send him. You can put ...
