Sorry, guys, but this really drives me nuts… I’ve waisted already several hours trying to perform the SIMPLIEST operation to rename the current Db… Why is it in influx so complicated…Why is it to hard for developers to add RenameDB command to CLI or something like this…
What I tried:
Ran the command like SELECT * INTO NewDB From OldDb - doesn’t work
Read the docs from official site and tried to run something like this
influxd restore -portable -db telegraf -newdb telegraf_bak path-to-backup - constantly throws errors whether it’s related to path or retention policy…
Tried to manipulate with storage files. But it keeps listing the original db names despite the the folders in wal. and data folders were renamed…
“Directly renaming a database in InfluxDB is not possible, so a common use for
the INTO clause is to move data from one database to another.”
https://docs.influxdata.com/influxdb/v1.2//query_language/data_exploration/
#the-into-clause
Also see Workaround to rename databases
Regards,
Antony.
Is it normal that it only copies just the float MEASUREMENTS?
I used following Query
SELECT * INTO <new_db>…:MEASUREMENT FROM <old_db>…/.*/ GROUP BY *
Thank you
