使用docker中的dexp和dimp命令备份和还原达梦数据库

关注

原创最新推荐文章于 2026-09-15 12:30:41 发布 342 阅读 AI 写同款· GEO 优化 ›

14.dimp导入、dexp导出达梦DM数据库 docker环境和windows环境用dimp导入、dexp导出DM达梦数据库；阅读详情


# 新创建一个dm实例
docker run -d -p 30236:5236 --name=dm82 --privileged=true -e LD_LIBRARY_PATH=/opt/dmdbms/bin -e PAGE_SIZE=16 -e EXTENT_SIZE=32 -e LOG_SIZE=1024 -e UNICODE_FLAG=1  -e INSTANCE_NAME=dm8 -v ${HOME}/data/dm8:/opt/dmdbms/data --network ke dm8_single:dm8_20240715_rev232765_x86_rh6_64 


# 备份
docker run -it --rm  --privileged=true \
-e LANG=C.UTF-8 \
-e LD_LIBRARY_PATH=/opt/dmdbms/bin \
-v ${HOME}/data-backup/dm8:/root/dm8backup \
--entrypoint ''  \
dm8_single:dm8_20240715_rev232765_x86_rh6_64 /opt/dmdbms/bin/dexp SYSDBA/SYSDBA001@172.23.118.250:30236 SCHEMAS=KING_KE FILE=$(date +%Y%m%d%H%M%S).dmp LOG=$(date +%Y%m%d%H%M%S).log DIRECTORY=/root/dm8backup
  

# 还原
docker run -it --rm  --privileged=true \
-e LANG=C.UTF-8 \
-e LD_LIBRARY_PATH=/opt/dmdbms/bin \
-v ${HOME}/data-backup/dm8:/root/dm8backup \
--entrypoint ''  \
dm8_single:dm8_20240715_rev232765_x86_rh6_64 /opt/dmdbms/bin/dimp SYSDBA/SYSDBA001@172.23.118.250:30236 SCHEMAS=KING_KE FILE=20241124115544.dmp LOG=$(date +%Y%m%d%H%M%S).log DIRECTORY=/root/dm8backup

收录于