Influx v1.8 CLI query gets Killed

n00b 0
Viewed 23

I'm looking at options to export data from InfluxDB to MySQL. I'm exploring the option to export the data to flat files for the import (so we don't have to hit our production InfluxDB instance).

When I execute the command influx -database 'mydb' -execute 'SELECT * FROM "1D"' -format csv > my-influx-all.csv it runs for about a minute and then outputs Killed.

My test DB is about 2.1GB in size atm so not large. The production DB is 51GB. Is there a flag I can pass so Influx CLI doesn't die? Or is there an alternate way to export data into a flat file?

influxdb
1 Answers

The query you can might hit an OOM. Further details should be found in the logs.

If you want to export the data in an readable format, you could try influx_inspect :

sudo influx_inspect export -database yourDatabase -out "influx_backup.db"
Munin0
Related