#!/bin/bash
# 该脚本用于备份开放平台(2.x)及化工平台(3.x)文件及数据，一般用于系统重装、数据迁移等情况。
# - 默认只备份1天历史轨迹数据，如果要修改请搜索-1day并修改为想要的值，比如-365day即表示备份最近1年的轨迹数据
# - 备份完成后会在当前目录下生成一个以日期和时间命名的zip文件（如202008242058.zip），将该文件下载备份即可

source /home/seekcy/.bash_profile

dir="$( cd "$( dirname "$0" )" && pwd )"

date=$(date +"%Y%m%d%H%M")
echo $date
rm -rf $date

mkdir $date
cd $date

is_new_db=`ls -l /home/seekcy/database/mysql/mysql.sock | wc -l`
is_tmp_db=`ls -l /tmp/mysql.sock | wc -l`
sock=""
if [ $is_new_db -gt 0 ]; then
  echo "using new socket"
  sock="/home/seekcy/database/mysql/mysql.sock"
elif [ $is_tmp_db -gt 0 ]; then
  echo "using tmp socket"
  sock="/tmp/mysql.sock"
else
  echo "using default socket"
  sock="/home/mysqldata/mysql/mysql.sock"
fi

echo $sock



# 备份开放平台
mkdir open
cd open
mongodump --port 47017 -d js_open_location_server -u jsopen -p JsOpenMongo2019 -o mongodata

historydate=$(date -d -1day +%Y-%m-%dT%H:%M:%SZ)
nowdate=$(date +%Y-%m-%dT%H:%M:%SZ)
echo $historydate
echo $nowdate

mkdir influxdata
cd influxdata
influxd backup -portable -database js_open_location -start $historydate -end $nowdate ./

cd ../
mysqldump -uroot -pPassword2017 -S $sock js_open_location_server > open.sql

mkdir js_open
cd js_open
mkdir location-server location-engine
cp -r /home/seekcy/js_open/*.sh ./
cp -r /home/seekcy/js_open/upload ./
cp -r /home/seekcy/js_open/webpage ./
cp /home/seekcy/js_open/location-server/*.sh location-server/
cp /home/seekcy/js_open/location-server/*.jar location-server/
cp -r /home/seekcy/js_open/location-server/config location-server/

cp /home/seekcy/js_open/location-engine/*.sh location-engine/
cp /home/seekcy/js_open/location-engine/*.jar location-engine/
cp -r /home/seekcy/js_open/location-engine/config location-engine/

cd ../../


# 备份化工平台3.x
#mkdir chem
#cd chem
#忽略巡检相关表
#mysqldump -uroot -pPassword2017 -S $sock joysuch_chemical --ignore-table=joysuch_chemical.patrol_area_data_center --ignore-#table=joysuch_chemical.patrol_employee_data_base --ignore-table=joysuch_chemical.patrol_event_base_data --ignore-#table=joysuch_chemical.patrol_path_data_center --ignore-table=joysuch_chemical.patrol_point_data_center --ignore-#table=joysuch_chemical.alarm_area_log --ignore-table=joysuch_chemical.area_day_data_display > chem.sql
#mysqldump -uroot -pPassword2017 -S $sock joysuch_chemical > chem.sql

#cp -r /home/seekcy/chemical-data ./
#zip -r -q ROOT.zip /home/seekcy/tomcat-chemical/webapps/ROOT

# 复制恢复脚本
cd ../
cp ../restore_*.sh ./
cp ../*.js ./

cd ../
zip -r -q $date".zip" $date 
rm -rf $date



#/usr/bin/ftp -n<<!
#open 47.107.190.236
#user ftpdb ftpdb321
#cd IT
#binary
#lcd $dir
#prompt
#put $date".zip" $date".zip"
#close
#bye
#!