在linux中备份influxdb时序数据库:
备份数据库:
[root@localhost /]# mkdir influx_backup
[root@localhost /]# cd ./influx_backup
[root@localhost /]# influxd backup -database xxxdb-retention autogen ./
可选参数:
-retention <retention policy name>
-shard <shard ID>
-since <date>
远程备份:(未测试)
$ influxd backup -database mydatabase -host 10.0.0.1:8088 /tmp/mysnapshot
生成的文件:
恢复:
语法:
influxd restore [ -metadir | -datadir ] <path-to-meta-or-data-directory> <path-to-backup>
influxd restore -database xxxxxdb -datadir /ect/var/lib/influxdb/data /home/influxdb_backup_Construction/
注意:influxdb的data路径和备份文件的路径
influxdb 启动:
[root@localhost /]# service influxdb start
[root@localhost /]# service influxdb stop
结果只有表恢复了,但是没有数据,
重新导入:
先进入backup目录,
[root@localhost influxdb_backup_Construction]#
//元数据导入
[root@localhost influxdb_backup_Construction]# influxd restore -metadir /var/lib/influxdb/meta ./
Using metastore snapshot: meta.00
//数据库导入
[root@localhost influxdb_backup_Construction]# influxd restore -database Construction -datadir /var/lib/influxdb/data ./
导入。。。。
//给与权限
[root@localhost influxdb_backup_Construction]# chown -R influxdb:influxdb /var/lib/influxdb
//重启服务
[root@localhost influxdb_backup_Construction]# service influxdb restart
//结束
进入客户端:
[root@localhost /]# influx
Connected to http://localhost:8086 version 1.2.4
InfluxDB shell version: 1.2.4
>
有身份验证时:
[root@localhost /]# influx -username root -password root
Connected to http://localhost:8086 version 1.2.4
InfluxDB shell version: 1.2.4
> show databases;
name: databases
name
----
_internal
Construction
> use Construction
Using database Construction
> show measurements
name: measurements
name
----
hour_2019
minute_2018
minute_2019
> select * from hour_2019