Influxdb oss restore process not working

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.