Copy data from Influx 1.8 to 1.12 on another Raspberry Pi 3B+

InfluxDB 1
,
1

How can I copy the data of an influxdb v1.8 to a influxdb v1.12 on another machine?
I already did on my old Raspberry Pi 3 B+ (InfluxDB 1.8) with old Buster:

influxd backup -portable /tmp/2026-02-08_influxdb_backup_portable

I copied then that directory to my new Raspberry Pi 3 B+ with Raspbian Trixie:

influxd restore -portable /tmp/2026-02-08_influxdb_backup_portable

This worked also. But now I want to migrate also the data which are saved since that restore also to the new Influx. I first tried to do the same again, but this doesnt work, I get the error:

#influxd restore -portable /tmp/2026-02-08_influxdb_backup_portable
2026/02/08 15:26:38 error updating meta: DB metadata not changed. database may already exist
restore: DB metadata not changed. database may already exist

How can I restore now just the new data since the restore?
Or do I need to delete the restored data (how?) and do all again just when I switch my two raspberries?
The thing is, that my old RP3 is in use and I get always new data into my influxdb, so when I switch I dont want to loose too much of the data.
Best would be if it were possible to just write the data from the old RP3 over the data from the new RP3 so that I loose only the minimum. How is that done?

Thank

2

The issue here is that you cannot restore a database onto a database that already exists with the same name. I would recommend using SELECT INTO to select and copy the data if possible. Otherwise, you’ll need to run DROP DATABASE and then do your restore.

3

OK thank, I just did it the hard way: I deleted the whole influxdb data folder on the new device:

sudo systemctl stop influxdb
sudo rm -rf /var/lib/influxdb/*
sudo systemctl start influxdb

I created then my only admin user again with:

CREATE USER admin WITH PASSWORD ‘12345’ WITH ALL PRIVILEGES

And after switching devices I did again a backup, send it with scp to the new device and restored it there.
This way I had a lack of about an hour of data, which is irrelelvant. Its data from electricity, water, gas and solar meters.

I am on 1.12.2 now, which seems to be some dead github release with wrong version tag:

root@rasp3:~#influx --version
InfluxDB shell version: 1.x-c9a9af2d63

But thats cosmetics :smirking_face: influxdb works as expected.

1 Like