I am trying to restore a backed up database into a new one using Influx v1.8.4. So far I have managed to successfully restore it into a backup database and then am trying to use the SELECT* INTO the original database. This then gives me a timeout error, so I then want to kind of split it in half and then do each half separately. The easiest way for me to do that is separating it by the MAC addresses (because there are 2 devices) but I am kinda stuck as to how to do it. Any suggestions on how to do this. This is what I have managed to do so far :
> USE backup > SELECT * INTO original.:MEASUREMENT FROM /.*/ GROUP BY * (this is where it timed out) ... > SHOW TAG VALUES ON backup WITH KEY = "mac" name: backup_measurements key value --- ----- mac E5213BE096F7 mac F54118464E6B > SELECT * INTO original.:MEASUREMENT FROM backup WHERE "mac" = 'F54118464E6B' GROUP BY * name: result time written ---- ------- 0 0 > SELECT * INTO original.:MEASUREMENT FROM /.*/ GROUP BY * ERR: retention policy not found: original
So what am I doing wrong ?