FreeBSD 14
Sponsored Link

InfluxDB : Backup and Restore2024/08/26

 

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

2024/08/26 10:12:11 backing up metastore to /home/influxd_backup/meta.00
2024/08/26 10:12:11 backing up db=test_database
2024/08/26 10:12:11 backing up db=test_database rp=autogen shard=3 to /home/influxd_backup/test_database.autogen.00003.00 since 0001-01-01T00:00:00Z
2024/08/26 10:12:11 backup complete:
2024/08/26 10:12:11     /home/influxd_backup/home/influxd_backup/meta.00
2024/08/26 10:12:11     /home/influxd_backup/home/influxd_backup/test_database.autogen.00003.00

root@dlp:~ #
ls -l /home/influxd_backup

total 10
drwx------  2 root wheel uarch    4 Aug 26 10:12 ./
drwxr-xr-x  5 root wheel uarch    5 Aug 26 10:12 ../
-rw-r--r--  1 root wheel uarch  486 Aug 26 10:12 meta.00
-rw-r--r--  1 root wheel uarch 2048 Aug 26 10:12 test_database.autogen.00003.00

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

root@dlp:~ #
influxd backup -database test_database -retention one_day -since 2024-08-26T00:00:00Z /home/influxd_backup

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

root@dlp:~ #
service influxd stop
# 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/db/influxdb/meta -datadir /var/db/influxdb/data -database test_database /home/influxd_backup

Using metastore snapshot: /home/influxd_backup/meta.00
2024/08/26 10:16:27 Restoring offline from backup /home/influxd_backup/test_database.*

root@dlp:~ #
chown -R influxd:influxd /var/db/influxdb/meta /var/db/influxdb/data

root@dlp:~ #
service influxd start
# verify resotored data

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

name: weather
time                           location  temperature
----                           --------  -----------
2024-08-26T01:19:54.407479784Z hiroshima 20
2024-08-26T01:19:57.936094746Z hiroshima 22
2024-08-26T01:20:01.344264152Z osaka     18
2024-08-26T01:20:04.71281686Z  osaka     19
Matched Content