每日定时导出docker内的达梦数据库中的某个表

1，建立脚本test.sh,并chmod 777

2、

#! /bin/bash
# backup table 

CURRENT_DATE=`date +%Y%m%d`
echo "show time"
echo $CURRENT_DATE

DATABASE_BACKUP_FILENAME="database_$CURRENT_DATE.dmp"
DATABASE_BACKUP_LOGFILE="database_$CURRENT_DATE.log"
DATABASE_BACKUP_DIR="/media/raid/database_backups"
DATABASE_BACKUP_HOST_DIR="/root/Downloads/backup/dmdb_files"


#backup all tables
docker exec -i container_name  /bin/bash -c  "cd /opt/dmdbms/bin && ./dexp SYSDBA/SYSDBA  file=$DATABASE_BACKUP_FILENAME log=$DATABASE_BACKUP_LOGFILE tables=tablename directory=$DATABASE_BACKUP_DIR"

#move backup to host
docker cp container_name:"$DATABASE_BACKUP_DIR/$DATABASE_BACKUP_FILENAME" "$DATABASE_BACKUP_HOST_DIR/$DATABASE_BACKUP_FILENAME"
docker cp container_name:"$DATABASE_BACKUP_DIR/$DATABASE_BACKUP_LOGFILE" "$DATABASE_BACKUP_HOST_DIR/$DATABASE_BACKUP_LOGFILE"

3、crontab -e 添加脚本
4、到出库删除tables即可，记得换成自己的模式ID与密码