摘要：上面是備份的結(jié)果，注意，備份完了之后是壓縮包的形式，所以請(qǐng)你先安裝壓縮工具，不會(huì)的還是麻煩百度下，實(shí)在簡(jiǎn)單成狗了。

前幾篇博客已經(jīng)相繼公開(kāi)了去轉(zhuǎn)盤(pán)網(wǎng)的所有技術(shù)細(xì)節(jié)，如下：

百度網(wǎng)盤(pán)爬蟲(chóng)

中文分詞算法

邀請(qǐng)好友注冊(cè)

js分頁(yè)部分代碼

這篇博客我將繼續(xù)公開(kāi)數(shù)據(jù)庫(kù)自動(dòng)備份的代碼?？梢赃@么說(shuō)，沒(méi)有數(shù)據(jù)庫(kù)，一切就是個(gè)蛋，沒(méi)有數(shù)據(jù)庫(kù)備份，一切還是個(gè)蛋，你可以想象數(shù)據(jù)庫(kù)備份多么重要。不會(huì)linux，不會(huì)寫(xiě)shell的朋友麻煩先去補(bǔ)補(bǔ)。不過(guò)你說(shuō)我牛逼，不補(bǔ)也能看懂，那沒(méi)問(wèn)題，哈哈，廢話不說(shuō)了。老規(guī)矩，上代碼：

#!/bin/bash
time=$(date +"%d-%m-%Y")
pre=/home/ubuntu #想放到那里麻煩自己配置下哈
if [ ! -d "$pre/data_backup/$time" ]
then
  mkdir -p $pre/data_backup/$time
  echo "create $pre/data_backup/$time"
else
  echo "exist $pre/data_backup/$time"
fi
if [ -d "$pre/data_backup/$time" ]
then
 mysqldump -h10.66.102.75 -uroot -p123456 --opt winrun user > $pre/data_backup/$time/user.sql
 mysqldump -h10.66.102.75 -uroot -p123456--opt winrun CategoryInfo  > $pre/data_backup/$time/CategoryInfo.sql
 mysqldump -h10.66.102.75 -uroot -p123456 --opt winrun admin_info > $pre/data_backup/$time/admin_info.sql
 mysqldump -h10.66.102.75 -uroot -p123456 --opt winrun admin_loginfo > $pre/data_backup/$time/admin_loginfo.sql
 mysqldump -h10.66.102.75 -uroot -p123456 --opt winrun admin_notice_info  > $pre/data_backup/$time/admin_notice_info.sql
 mysqldump -h10.66.102.75 -uroot -p123456--opt winrun advertising_info  > $pre/data_backup/$time/advertising_info.sql
 mysqldump -h10.66.102.75 -uroot -p123456--opt winrun ajax_request_info  > $pre/data_backup/$time/ajax_request_info.sql
 mysqldump -h10.66.102.75 -uroot -p123456 --opt winrun bt_file_info  > $pre/data_backup/$time/bt_file_info.sql
 echo "backup finished"
 cd $pre/data_backup #enter dir
 zip -r $time.zip $time/
 rm -fr $time #delete
 cd -
 echo "zip backup database finished"
else
 echo "can not find backup file"
fi

注意，我的密碼我已經(jīng)改了，這個(gè)不能告訴你們，所以喜歡copy的孩子麻煩自己該密碼。下面我教大家玩下crotab，代碼如下：

# Edit this file to introduce tasks to be run by cron.
#
# Each task to run has to be defined through a single line
# indicating with different fields when the task will be run
# and what command to run for the task
#
# To define the time you can provide concrete values for
# minute (m), hour (h), day of month (dom), month (mon),
# and day of week (dow) or use "*" in these fields (for "any").#
# Notice that tasks will be started based on the cron"s system
# daemon"s notion of time and timezones.
#
# Output of the crontab jobs (including errors) is sent through
# email to the user the crontab file belongs to (unless redirected).
#
# For example, you can run a backup of all your user accounts
# at 5 a.m every week with:
# 0 5 * * 1 tar -zcf /var/backups/home.tgz /home/
#
# For more information see the manual pages of crontab(5) and cron(8)
#
# m h  dom mon dow   command
10 1 * * 1,3,5  /home/backup.sh >> /home/backup.log

有用的是最下面的這一句，看到?jīng)]有，備份完了還得有個(gè)log，不然誰(shuí)知道備份成什么樣子了，一點(diǎn)都不懂crontab麻煩自己百度下，我也一時(shí)給你講不明白。

上面是備份的結(jié)果，注意，備份完了之后是壓縮包的形式，所以請(qǐng)你先安裝壓縮工具，apt-get install XXXX 不會(huì)的還是麻煩百度下，實(shí)在簡(jiǎn)單成狗了。

技術(shù)在于分享，開(kāi)源，去轉(zhuǎn)盤(pán)不吝嗇任何技術(shù)，歡迎關(guān)注微博或者微信，隨時(shí)交流。本人建立個(gè)qq群作為去轉(zhuǎn)盤(pán)網(wǎng)的官方群，人數(shù)現(xiàn)在也不多，如果有興趣的話來(lái)逛逛吧，多個(gè)粉絲去轉(zhuǎn)盤(pán)多一份熱鬧，qq群號(hào)：512245829