InfluxDB : Backup and Restore2024/06/10 |
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/06/10 00:45:54 backing up metastore to /home/influxd_backup/meta.00 2024/06/10 00:45:54 backing up db=test_database 2024/06/10 00:45:54 backing up db=test_database rp=one_day shard=3 to /home/influxd_backup/test_database.one_day.00003.00 since 0001-01-01T00:00:00Z 2024/06/10 00:45:54 backup complete: 2024/06/10 00:45:54 /home/influxd_backup/home/influxd_backup/meta.00 2024/06/10 00:45:54 /home/influxd_backup/home/influxd_backup/test_database.one_day.00003.00root@dlp:~# ll /home/influxd_backup total 16 drwx------ 2 root root 4096 Jun 10 00:45 ./ drwxr-xr-x 4 root root 4096 Jun 10 00:45 ../ -rw-r--r-- 1 root root 485 Jun 10 00:45 meta.00 -rw-r--r-- 1 root root 2048 Jun 10 00:45 test_database.one_day.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-06-10T00:00:00Z /home/influxd_backup |
[2] | Restore a Backup database. |
# 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 2024/06/10 00:47:33 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 ---- -------- ----------- 2024-06-10T00:45:32.55859514Z hiroshima 20 2024-06-10T00:45:35.902551825Z hiroshima 22 2024-06-10T00:45:39.143684421Z osaka 18 2024-06-10T00:45:42.023638133Z osaka 19 |
Sponsored Link |
|