哞丫哞

建立一script，設權限為755

#!/bin/bash

#要備份的DB清單

BACKUP_LIST="/home/back_list"

#要備份到什麼地方

BACKUP_PATH="/home/Backup_DB"

BACKUP_TIME=`date +%Y%m%d_%H`
BACKUP_FOLDER=$BACKUP_PATH/$BACKUP_TIME

if [! -d $BACKUP_FOLDER ]; then
    /bin/mkdir -p $BACKUP_FOLDER
fi

匯出
mysqldump -u root -p --default-character-set=utf8 comp > /tmp/comp.sql

會連function一起dump
mysqldump -u root -p --default-character-set=utf8 -R comp > /tmp/comp.sql

還原
mysql -u root -p --default-character-set=utf8 cjfh < /tmp/table或DB

--default-character-set=utf8

指定匯入或匯出為utf8格式

#!/bin/bash
BACKUP_LIST="/tmp/back_list"

#建立一清單，裡面填寫要dump出的資料表名稱

BACKUP_PATH="/tmp/mysqldump"

#要dump出來的儲存路徑

BACKUP_TIME=`date +%Y%m%d_%H`
BACKUP_FOLDERT2="$BACKUP_PATH/$BACKUP_TIME/T2"

if [ ! -d $BACKUP_FOLDERT2 ]; then
        /bin/mkdir -p $BACKUP_FOLDERT2
fi

cat $BACKUP_LIST | while read DB
do

                                                          #這裡是指針對test資料庫中要dump哪些table出來

                                                          #所要dump出來的table 可寫在 back_list中

/usr/bin/mysqldump -u root -p123456 --default-character-set=UTF8 test $DB > $BACKUP_FOLDERT2/$DB.sql

    if [ $? -ne "0" ]; then
    echo "  [ERROR] "$DB  >> $BACKUP_PATH/log
    fi

done

=======================================

日後如果常常要撈取表格資料只要修改這back_list內的表格名稱就好，比較不用擔心指令打錯