How to change location of Influxdb storage folder?

Question

I've Installed package from the official site by instruction. By default the physical destination of database folder is /opt/influxdb/shared.

I've tried to change properties of config file and written it properly. But after that I can't start the influxdb service.

[storage]

dir = "/media/alex/Second/InfluxStorage/data/db" //my settings

How I can change the default database directory ?

The problem was solved by changing rights of access to external disk storage(the destination that I want to store influxdb). — Alexey Batsman, Feb 06 '15 at 08:59
You should write your solution as an official answer for others to enjoy. — Eldad Assis, Jan 01 '17 at 12:44

Gustavo Bezerra · Answer 1 · 2020-11-30T02:11:08.563

29

EDIT: This is for InfluxDB v1.x only. It has been reported to not work for InfluxDB v2.x.

Make a new directory where you want to put your data and set the appropriate permissions, e.g.:

mkdir /new/path/to/influxdb
sudo chown influxdb:influxdb influxdb

Edit the following three lines of your /etc/influxdb/influxdb.conf (/usr/local/etc/influxdb.conf on macOS) so that they point to your new location:

# under [meta]
dir = "/new/path/to/influxdb/meta"

# under [data]
dir = "/new/path/to/influxdb/data"
wal-dir = "/new/path/to/influxdb/wal"

Restart the InfluxDB daemon.

sudo service influxdb restart  # Ubuntu/Debian
brew services restart influxdb  # macOS/homebrew

Done!

In case you want to move existing data, just simply copy the existing data (location can be found at influxdb.conf; /var/lib/influxdb on Ubuntu/Debian) to your new desired location before editing influxdb.conf and make sure the new folder has the appropriate permissions/ownership.

There is some information about backups/restores on the official docs, however just plain copying worked for me.

The above was tested on InfluxDB v1.2 on macOS/Ubuntu/Raspbian.

edited Nov 30 '20 at 02:11

answered Mar 21 '17 at 04:40

Gustavo Bezerra

9,984
4
40
48

moved and cannot find databases. Anyone has a clue? – Eric Wang Feb 28 '18 at 10:56
@EricWang What version of InfluxDB were you using? – Gustavo Bezerra May 24 '18 at 03:05
1

If you want to copy your existing data, make also sure that you set the permissions and owner for the files correct. Otherwise influxdb won't start. `sudo cp -rp /old/path /new/path` works fine. – Markus Rudel Jul 07 '18 at 22:30
@GustavoBezerra I am using v1.2.2.1. Is there anything to worry about if I would like to move data between different version? – Eric Wang Aug 30 '18 at 02:37
2

For the record I just followed these steps for Influxdb 1.7.8 for Windows and it worked perfectly. – Balash Dec 24 '19 at 01:49

score 10 · Answer 2 · answered Jan 01 '21 at 19:49

For InfluxDB 2.0:

In InfluxDB 2.0 the data directories are below ~/.influxdbv2 by default.

Actually, there are 2 data storages for bolt (various key-value configurations) and engine (the TSM database).

From the documentation, to change the location to the bolt database:

Default: ~/.influxdbv2/influxd.bolt
influxd flag: influxd --bolt-path=~/.influxdbv2/influxd.bolt
Environment variable: export INFLUXD_BOLT_PATH=~/.influxdbv2/influxd.bolt
Configuration file: bolt-path: /users/user/.influxdbv2/influxd.bolt

From the documentation, to change the location to the engine database:

Default: ~/.influxdbv2/engine
influxd flag: influxd --engine-path=~/.influxdbv2/engine
Environment variable: export INFLUXD_ENGINE_PATH=~/.influxdbv2/engine
Configuration file: engine-path: /users/user/.influxdbv2/engine

Default values for Debian & Ubuntu (config.toml): `bolt-path = "/var/lib/influxdb/influxd.bolt"` `engine-path = "/var/lib/influxdb/engine"` — VAV, Apr 05 '21 at 18:30

How to change location of Influxdb storage folder?

2 Answers2