国产亚洲情侣久久精品,久久综合日韩亚洲精品色,亚洲高清中文字幕综合网

備份mysql數(shù)據(jù)庫(kù)的shell腳本

領(lǐng)導(dǎo)說(shuō)每天都需要備份一下mysql，好吧，我總不能天天手動(dòng)去弄，所以我自己寫(xiě)了一份shell腳本用來(lái)自動(dòng)備份，crontab還是很好的呵呵

#! /bin/bash
2

#define mysql path
3

MYSQL_BIN_PATH=/local/akazam/servers/akazamdb51/bin #這個(gè)是你MYSQL的安裝目錄
4

MYSQL_BACKUP_PATH=/local/akazam/mysqlbak#你要備份的目錄
5

SOCKET_FILE=/tmp/mysql.sock
6

if [ $# -eq 0 ]
8

then
9

echo "ERROR:Usage:please input mysql arguments" 1>&2
10

echo "The arguments like this" 1>&2
11

echo "./mysqlbackup.sh database [user] [password] [port] [bakpath]" 1>&2
12

echo "default user is akazam ,default password is dbacc355 and" 1>&2
13

echo "default port is 3306,if you all understand ,you can try now!" 1>&2
14

exit 1
15

fi
16

#get datebase
18

db=$1
19

#get user
20

if [ "$2" = "" ]
21

then
22

user="akazam"
23

else
24

user=$2
25

fi
26

#get password
27

if [ "$3" = "" ]
28

then
29

password="dbacc355"
30

else
31

password=$3
32

fi
33

#get port
34

if [ "$4" = "" ]
35

then
36

port="3306"
37

else
38

port=$4
39

fi
40

#get backpath
41

if [ "$5" = "" ]
42

then
43

backpath=$MYSQL_BACKUP_PATH
44

else
45

backpath=$5
46

fi
47

#get the day before yesterday
48

byd=$(date --date='1 days ago' "+%Y%m%d")
49

#get today
50

today=$(date +%Y%m%d)
51

#backup today's mysqldump
52

if [ ! -d $MYSQL_BACKUP_PATH ]
53

then
54

mkdir $MYSQL_BACKUP_PATH
55

fi
56

cd $MYSQL_BIN_PATH
57

./mysqldump -u$user -p$password -h localhost $db --socket=$SOCKET_FILE --opt>$backpath/$db$today
58

echo "backup result is:$bakresult"
59

#delete the day before's backup
60

rm -rf $backpath/$db$byd
61

echo "you delete backup mydqldump is $db$byd and need backup mysqldump is $db$today"
63

用法嘛按照./mysqlbackup.sh database [user] [password] [port] [bakpath] 這種方式就可以了，還是很方便的

posted on 2011-03-17 09:33 Cloud kensin 閱讀(241) 評(píng)論(0) 編輯收藏所屬分類: Linux 、數(shù)據(jù)庫(kù)

新用戶注冊(cè) 刷新評(píng)論列表


只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問(wèn) 管理
相關(guān)文章: 如何監(jiān)控tomcat進(jìn)程并殺死它備份mysql數(shù)據(jù)庫(kù)的shell腳本在unbutu中安裝JDK Ubuntu觸摸板禁用的解決方法 [轉(zhuǎn)載]在linux下部署redmine 關(guān)于Ubuntu上tomcat出現(xiàn)的錯(cuò)誤小結(jié) Ubuntu 9.04 Server Apache + SVN 的搭建筆記

備份mysql數(shù)據(jù)庫(kù)的shell腳本

導(dǎo)航

統(tǒng)計(jì)

常用鏈接

留言簿(4)

隨筆分類

相冊(cè)

相冊(cè)

搜索

最新評(píng)論