Tao

          Tao obeys its own inherent Nature

          How To: using bash script to backup MySql

          Create a file backup_db.sh, and paste the following contents:
          #get the first parameter as the database name
          DATABASE=$1
          #if no database specified, then you can set the default one
          if [ -z $DATABASE ]; then
          DATABASE=default_database_name_here
          fi

          #mysql user and password to backup the database. MYSQLUSER=mysql_user MYSQLPWD=mysql_password #path to backup ARCHIVEPATH=~/backup/db_backup DATE=`date +%Y%m%d` YEAR=`date +%Y` MONTH=`date +%m` FOLDER_MONTH=$ARCHIVEPATH/$YEAR$MONTH if [ ! -d $FOLDER_MONTH ]; then
          echo "mkdir $FOLDER_MONTH" mkdir $FOLDER_MONTH fi # Backup echo "mysqldump -u$MYSQLUSER -p$MYSQLPWD $DATABASE | gzip > $FOLDER_MONTH/$DATABASE-$DATE.sql.gz" mysqldump -u$MYSQLUSER -p$MYSQLPWD $DATABASE | gzip > $FOLDER_MONTH/$DATABASE-$DATE.sql.gz

           

          and you can add the script to cron job under *nix and schedule under windows:

          *nix:

          Save the following text in file: db_backup.at

          10 * * * * ~/backup/backup_db.sh databasename

          and call

          crontab db_backup.at

          You need to change the period to run the script for your business, e.g. each day, each week etc.


           

          posted on 2007-11-13 15:49 wade 閱讀(274) 評論(0)  編輯  收藏 所屬分類: LinuxMysql

          導航

          <2007年11月>
          28293031123
          45678910
          11121314151617
          18192021222324
          2526272829301
          2345678

          統計

          常用鏈接

          留言簿(7)

          隨筆分類

          隨筆檔案

          相冊

          Photo

          搜索

          最新評論

          閱讀排行榜

          評論排行榜

          主站蜘蛛池模板: 和政县| 扎鲁特旗| 乌兰察布市| 响水县| 鄂伦春自治旗| 南岸区| 沈丘县| 五莲县| 德惠市| 思南县| 浮梁县| 清涧县| 根河市| 清丰县| 横山县| 高台县| 凉山| 高淳县| 青阳县| 四会市| 涟源市| 上思县| 石城县| 阜南县| 定陶县| 鹰潭市| 河北省| 景谷| 麟游县| 开封县| 九龙城区| 新宾| 平昌县| 乌拉特前旗| 三亚市| 司法| 宜阳县| 武威市| 四子王旗| 上虞市| 合川市|