备份数据库脚本-KeepStudy

备份数据库脚本

```shell
#!bin/bash
#备份数据库脚本

USERNAME="root"
PASSWORD="root"
LOGBACKPATH="/data/mysql_backup_ok"

curday=`date +%Y-%m-%d-%H-%M-%S`
for db in game_backstage hj_game_backstage
do
  echo $db
  for tb in c_ac_gift1 c_ac_reward1 c_activity1 c_advice c_ban c_ban_ip_dev c_charge_dc_set c_chat_level_limit c_chat_times_limi c_chat_word_limit c_email c_email_temp c_inside c_inside_deal_item_set c_inside_deal_role_set c_inside_deal_set c_inside_e c_inside_ewai c_inside_jjc c_inside_kf c_inside_kf_set c_inside_resource c_marquee c_name_server c_register_limit c_sens_word c_vip_qq c_voice_set c_white_ip g_platform g_server g_server_cross g_server_merge gd_pay gd_pay_lj gd_reg gd_rename gd_role gd_vip s_menu s_user s_user_group stat_account stat_activity stat_chumo stat_dev stat_digs stat_economic_gold stat_economic_gold_bind stat_everyday stat_first_pay stat_keep stat_keep_account stat_level_lost stat_ltv stat_lv stat_online stat_online_time stat_open_gift stat_pay_analsis stat_pay_contribution stat_pay_dc stat_pay_lj_dangci stat_platform stat_shop stat_task stat_vip
  do
    mysqldump -t -n --skip-comments --skip-add-drop-table --skip-add-locks --no-tablespaces --compact --databases $db --tables $tb -u${USERNAME} -p${PASSWORD} > $LOGBACKPATH/$db/"$tb".sql
  done
  cd $LOGBACKPATH/$db/
  zip -mq ${curday}.zip *'.sql'
  cd ..
done
echo "success"
exit 0
```

顶部

Shell应用

目录

相关推荐