数据库备份功能并导出

1、备份数据库脚本 操作系统CentOs

#!/bin/bash
user=@[USER]
password=@[PASSWORD]
database=@[DATABASE]
filename=@[FILENAME].zip
ipaddr=10.1.*.*
docker exec -i mysql sh<<EOF 
mysqldump --skip-opt -u${user} -p${password} ${database} | gzip > /tmp/${filename};
EOF
docker cp mysql:/tmp/${filename} /tmp/${filename}
cd /tmp/
curl -i -X POST "http://${ipaddr}/vm-service/f2cctl/backup/import" -H "accept: */*" -H "Content-Type:multipart/form-data" -F "file=@${filename};type=application/zip"
rm -rf /tmp/${filename}

2、备份数据库  Windows Server 64 位   bat

user=@[USER]

password=@[PASSWORD]

database=@[DATABASE]

filename=@[FILENAME]

ipaddr=10.1.*.*

cd @[PHYSICALPATH]

expdp @[USER]/@[PASSWORD]/@[DATABASE] directory=@[LOGICALPATH] dumpfile=@[FILENAME].DMP logfile=@[FILENAME].LOG

zip -j @[FILENAME].zip @[FILENAME].DMP  @[FILENAME].log

pscp -P 22 -l root -pw ***@123 @[FILENAME].zip 10.1.*.*:/opt/fit***/sftp/sftpuser/upload/