influxdb数据库备份和恢复数据

导出数据库数据

influxd backup -portable -database monidb /backup  # 备份数据
tar -cvf backup.tar /backup  # 打包数据

解压缩备份数据

/ # tar -xvf backup.tar
backup/
backup/20180904T092657Z.meta
backup/20180904T092657Z.s2.tar.gz
backup/20180904T092657Z.s3.tar.gz
backup/20180904T092657Z.s4.tar.gz
backup/20180904T092657Z.s5.tar.gz
backup/20180904T092657Z.s6.tar.gz
backup/20180904T092657Z.s7.tar.gz
backup/20180904T092657Z.s8.tar.gz
backup/20180904T092657Z.s9.tar.gz
backup/20180904T092657Z.s10.tar.gz
backup/20180904T092657Z.s11.tar.gz
backup/20180904T092657Z.s12.tar.gz
backup/20180904T092657Z.s13.tar.gz
backup/20180904T092657Z.s14.tar.gz
backup/20180904T092657Z.s16.tar.gz
backup/20180904T092657Z.s17.tar.gz
backup/20180904T092657Z.s18.tar.gz
backup/20180904T092657Z.s19.tar.gz
backup/20180904T092657Z.s20.tar.gz
backup/20180904T092657Z.s21.tar.gz
backup/20180904T092657Z.s22.tar.gz
backup/20180904T092657Z.s23.tar.gz
backup/20180904T092657Z.s24.tar.gz
backup/20180904T092657Z.s25.tar.gz
backup/20180904T092657Z.manifest

恢复备份数据到数据库

/ # influxd restore -portable ./backup
2018/09/04 10:45:06 Restoring shard 9 live from backup 20180904T092657Z.s9.tar.gz
2018/09/04 10:45:06 Restoring shard 10 live from backup 20180904T092657Z.s10.tar.gz
2018/09/04 10:45:06 Restoring shard 18 live from backup 20180904T092657Z.s18.tar.gz
2018/09/04 10:45:06 Restoring shard 25 live from backup 20180904T092657Z.s25.tar.gz
2018/09/04 10:45:06 Restoring shard 6 live from backup 20180904T092657Z.s6.tar.gz
2018/09/04 10:45:06 Restoring shard 7 live from backup 20180904T092657Z.s7.tar.gz
2018/09/04 10:45:06 Restoring shard 8 live from backup 20180904T092657Z.s8.tar.gz
2018/09/04 10:45:06 Restoring shard 11 live from backup 20180904T092657Z.s11.tar.gz
2018/09/04 10:45:06 Restoring shard 13 live from backup 20180904T092657Z.s13.tar.gz
2018/09/04 10:45:06 Restoring shard 19 live from backup 20180904T092657Z.s19.tar.gz
2018/09/04 10:45:06 Restoring shard 22 live from backup 20180904T092657Z.s22.tar.gz
2018/09/04 10:45:06 Restoring shard 23 live from backup 20180904T092657Z.s23.tar.gz
2018/09/04 10:45:06 Restoring shard 5 live from backup 20180904T092657Z.s5.tar.gz
2018/09/04 10:45:06 Restoring shard 14 live from backup 20180904T092657Z.s14.tar.gz
2018/09/04 10:45:06 Restoring shard 16 live from backup 20180904T092657Z.s16.tar.gz
2018/09/04 10:45:06 Restoring shard 17 live from backup 20180904T092657Z.s17.tar.gz
2018/09/04 10:45:06 Restoring shard 21 live from backup 20180904T092657Z.s21.tar.gz
2018/09/04 10:45:06 Restoring shard 24 live from backup 20180904T092657Z.s24.tar.gz
2018/09/04 10:45:06 Restoring shard 12 live from backup 20180904T092657Z.s12.tar.gz
2018/09/04 10:45:06 Restoring shard 3 live from backup 20180904T092657Z.s3.tar.gz
2018/09/04 10:45:06 Restoring shard 4 live from backup 20180904T092657Z.s4.tar.gz
2018/09/04 10:45:06 Restoring shard 20 live from backup 20180904T092657Z.s20.tar.gz
2018/09/04 10:45:06 Restoring shard 2 live from backup 20180904T092657Z.s2.tar.gz
### InfluxDB 数据库备份方法及操作流程 对于 InfluxDB备份,可以通过官方工具 `influxd backup` 来完成。以下是详细的说明以及相关注意事项: #### 使用 influxd backup 工具进行备份 `influxd backup` 是 InfluxDB 提供的一个命令行工具,用于创建数据库的完整副本。它支持对整个实例或者特定 Bucket 进行备份。 1. **启动本地 InfluxDB 实例** 需要先运行 InfluxDB 服务以便能够正常连接并执行备份操作。这通常涉及启动 `main.go` 文件中的入口程序[^1]。 2. **执行备份命令** 下面是一个典型的备份命令结构: ```bash influxd backup -host localhost:8088 /path/to/backup/directory ``` 上述命令会将当前 InfluxDB 中的数据备份至 `/path/to/backup/directory` 路径下的目录中。如果仅需针对某个具体的 bucket 或者 retention policy (RP) 执行备份,则可附加参数来限定范围[^4]: ```bash influxd backup -portable -bucket my-bucket-name -retention-policy rp_name -host localhost:8088 /path/to/specific_backup/ ``` 3. **验证备份数据的有效性** 完成备份之后,建议按照简单的恢复测试方式确认备份文件无误[^2]。例如尝试在一个全新的环境中加载这些备份文件,并检查原始数据是否被成功还原。 #### 注意事项 - 如果使用的是较新的版本(如 v2.x),需要注意语法可能有所变化,具体可以查阅对应版本文档获取最新指导。 - 对于生产环境而言,在实施任何大规模变更之前务必做好充分准备多次演练,确保过程稳定可靠。 ```python import os os.system('influxd backup -host localhost:8088 ./my_backup') print("Backup completed.") ``` 以上脚本展示了如何利用 Python 调用系统命令实现自动化备份功能。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值