Inability to import a previously exported database using the Influx CLI tool

influxdata / docs-v2

InfluxData Documentation that covers InfluxDB Cloud, InfluxDB OSS 2.x, InfluxDB OSS 1.x, InfluxDB Enterprise, Telegraf, Chronograf, Kapacitor, and Flux.

https://docs.influxdata.com

MIT License

72 stars 263 forks source link

Inability to import a previously exported database using the Influx CLI tool #2488

Open bogo666 opened 3 years ago

bogo666 commented 3 years ago

The influx CLI documentation describes an "-import" option having the description "Import a previous database export from file".

However, I cannot find docs on support for the influx CLI tool having such export functionality.

There are influxd commands for backup and restore, but is the backup an "export" usable by the influx CLI -import command?

Relevant URLs

https://docs.influxdata.com/influxdb/v1.8/tools/influx-cli/

sanderson commented 3 years ago

@bogo666 Thanks for asking. We'll get some more information and guidance from our engineering team.

@influxdata/edge with the InfluxDB 1.8 influx command, what file format does the -import flag expect? Should this just be line protocol or a full export file that includes the DDL?

davidby-influx commented 3 years ago

@sanderson & @bogo666 - the 1.8 import requires DDL and DML commands like a full export file, with the comment lines that provide database and retention policy, etc.