CentOS Stream 9
Sponsored Link

InfluxDB : Backup and Restore
2022/11/16
 
This is how to back up and restore InfluxDB database.
[1] Back up a database.
# backup [test_database] to [/home/influxd_backup]

[root@dlp ~]#
influxd backup -database test_database /home/influxd_backup

2022/11/16 10:49:29 backing up metastore to /home/influxd_backup/meta.00
2022/11/16 10:49:29 backing up db=test_database
2022/11/16 10:49:29 backing up db=test_database rp=one_day shard=4 to /home/influxd_backup/test_database.one_day.00004.00 since 0001-01-01T00:00:00Z
2022/11/16 10:49:29 backup complete:
2022/11/16 10:49:29     /home/influxd_backup/home/influxd_backup/meta.00
2022/11/16 10:49:29     /home/influxd_backup/home/influxd_backup/test_database.one_day.00004.00

[root@dlp ~]#
ll /home/influxd_backup

total 8
-rw-r--r--. 1 root root  496 Nov 16 10:49 meta.00
-rw-r--r--. 1 root root 2048 Nov 16 10:49 test_database.one_day.00004.00

# possible to backup specific retention policy or retention duration like follows

[root@dlp ~]#
influxd backup -database test_database -retention one_day -since 2022-11-16T00:00:00Z /home/influxd_backup

[2] Resrore a Backup database.
# stop service before restoring

[root@dlp ~]#
systemctl stop influxdb
# run restore command
# [-metadir] : target directory meta data is restored (follow is the default location)
# [-datadir] : target directory database is restored (follow is the default location)
# [-database] : target database name restored

[root@dlp ~]#
influxd restore -metadir /var/lib/influxdb/meta -datadir /var/lib/influxdb/data -database test_database /home/influxd_backup

Using metastore snapshot: /home/influxd_backup/meta.00
2022/11/16 10:51:26 Restoring offline from backup /home/influxd_backup/test_database.*

[root@dlp ~]#
chown -R influxdb:influxdb /var/lib/influxdb/{meta,data}

[root@dlp ~]#
systemctl start influxdb
# verify resotored data

[root@dlp ~]#
influx -username admin -password adminpassword -database test_database -precision rfc3339 -execute 'select * from weather'

name: weather
time                           location  temperature
----                           --------  -----------
2022-11-16T01:48:46.805015519Z hiroshima 20
2022-11-16T01:48:50.445558633Z hiroshima 22
2022-11-16T01:48:54.517994372Z osaka     18
2022-11-16T01:48:58.142419227Z osaka     19
Matched Content