InfluxDB : Backup and Restore2026/06/03

	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

2026/06/03 00:11:10 backing up metastore to /home/influxd_backup/meta.00
2026/06/03 00:11:10 backing up db=test_database
2026/06/03 00:11:10 backing up db=test_database rp=autogen shard=4 to /home/influxd_backup/test_database.autogen.00004.00 since 0001-01-01T00:00:00Z
2026/06/03 00:11:10 backup complete:
2026/06/03 00:11:10     /home/influxd_backup/home/influxd_backup/meta.00
2026/06/03 00:11:10     /home/influxd_backup/home/influxd_backup/test_database.autogen.00004.00

root@dlp:~#

ll /home/influxd_backup

total 16
drwx------ 2 root root 4096 Jun  3 00:11 ./
drwxr-xr-x 4 root root 4096 Jun  3 00:11 ../
-rw-r--r-- 1 root root  467 Jun  3 00:11 meta.00
-rw-r--r-- 1 root root 2048 Jun  3 00:11 test_database.autogen.00004.00

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

root@dlp:~#

influxd backup -database test_database -retention one_day -since 2026-06-02T00:00:00Z /home/influxd_backup

[2]	Restore 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
2026/06/03 00:13:37 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
----                           --------  -----------
2026-06-02T23:57:19.493794162Z hiroshima 20
2026-06-02T23:57:22.958137442Z hiroshima 22
2026-06-02T23:57:25.998799117Z osaka     18
2026-06-02T23:57:30.791238748Z osaka     19

Matched Content