Lost measurements after restoring a database from backup

backup
influxdb
#1

Hi all,

I hope you can help me out as I can not restore a backed up database and a great deal of my measurements are gone with the wind :frowning:

I had Influxdb Version ~1.0 on a old PC. I created a backup by this commands:

$backup -database mydb ./bkp

Then the content of this bkp folder are now:
β”œβ”€β”€ meta.00
β”œβ”€β”€ mydb.autogen.00110.00
└── mydb.autogen.00118.00

Then on a new PC with fresh install of influxdb v1.5 I restored this database:

$influxd restore -database mydb -datadir /var/lib/influxdb/data ./bkp/

The problem:

I can only see measurements for the last ~24 hours of the measurement…while I had almost 3 weeks of measurements.

Can you please tell me what could have gone wrong? The backup folder is 19MB in size and I think the data should be there but why I can not see the data?

#3

Hi @embedonix, the docs indicate that the offline legacy restore process can result in data loss. I’m not sure if that’s what is happening here, but have you tried restoring with the -online or -portable flag? It looks like those features are new in 1.5, so it might be worth trying.

#4

Here are the relevant 1.5 docs: https://docs.influxdata.com/influxdb/v1.5/administration/backup_and_restore/#restore-legacy