I’ve recently backed up my Influx database from a docker container and have now a backup file in the format of .tar.gz. I wanted to import the data from this file into another Influx database that is also running inside of a docker container.
What I tried to do was using Chronograf and its “Write Data” feature to import the content of the backup since it supports .gz files, but it seems that Chronograf only supports files that are up to 25MB in size and this backup of mine is 70MB.
I’ve searched for other possible methods to solve this in the “Docker Influx Documentation” and “InfluxDB Shell Documentation”. The only thing I found relevant was the “-import” option that is refenced in the Shell Documentation. I tried using it but to no avail. Any command that wasn’t a direct query in the InfluxDB shell was rejected and all I got was an error message that said:
ERR: error parsing query: found influx, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
If someone has any tips on how to solve this it would be appreciated.
EDIT: Just to be clear, I’m on Windows 10 at the moment