I have taken backup from one influxdb oss instance using instructions in this page-
It works well and data gets written as per CLI success status. But I am not able to locate the data in particular DB that I restored. I found that data gets written on disk.
It seems the "select * into " query to copy all the measurements in the dB is not working.
I need to take incremental backup every hour and want to restore on disaster recovery site. The database will be present every time I restore, so I have to take option of temporary dB .
Please suggest, I am really stuck on this.