Backup influxdb 1.2.2 databases and restore it to influxdb 1.7.2


#1

Hi,

I am running influxdb 1.2.2.

> ./influx
> Connected to http://localhost:8086 version 1.2.2
> InfluxDB shell version: 1.2.2
> > show databases;
> name: databases
> name
> ----
> _internal
> application
> system
> events

I did ./influxd backup -database events /opt/data but it backups only metastore. How do i backup all databases and restore it to 1.7.2. Am i doing it correctly?

Please suggest.

Best Regards,

Kaushal


#2

You should be able to backup everything with the influxd backup command:

influxd backup -portable <path-to-backup> should backup everything.


#3

Hi Katy,

I am facing the below issue. Please suggest further. How do i restore the backup to Influxdb 1.7.2

[root@bin]# ll
total 53920
-rwxr-xr-x. 1 root root  7727978 Aug 15  2017 influx
-rwxr-xr-x. 1 root root 17425099 Aug 15  2017 influxd
-rwxr-xr-x. 1 root root  9117049 Aug 15  2017 influx_inspect
-rwxr-xr-x. 1 root root  8066872 Aug 15  2017 influx_stress
-rwxr-xr-x. 1 root root 12868847 Aug 15  2017 influx_tsm
[root@bin]# ps aux | grep influx
root     22516  0.0  0.0 112708   980 pts/0    S+   02:31   0:00 grep --color=auto influx
[root@bin]# **influxd backup -portable /opt/influxdbbackup**
2019/01/09 02:31:11 backing up metastore to /opt/influxdbbackup/meta.00
2019/01/09 02:31:11 Download shard 0 failed dial tcp [::1]:8088: connect: connection refused.  Waiting 2s and retrying (0)...
2019/01/09 02:31:13 Download shard 0 failed dial tcp [::1]:8088: connect: connection refused.  Waiting 2s and retrying (1)...
2019/01/09 02:31:15 Download shard 0 failed dial tcp [::1]:8088: connect: connection refused.  Waiting 2s and retrying (2)...
2019/01/09 02:31:17 Download shard 0 failed dial tcp [::1]:8088: connect: connection refused.  Waiting 2s and retrying (3)...
2019/01/09 02:31:19 Download shard 0 failed dial tcp [::1]:8088: connect: connection refused.  Waiting 2s and retrying (4)...
2019/01/09 02:31:21 Download shard 0 failed dial tcp [::1]:8088: connect: connection refused.  Waiting 2s and retrying (5)...
2019/01/09 02:31:23 Download shard 0 failed dial tcp [::1]:8088: connect: connection refused.  Waiting 3.01s and retrying (6)...

Thanks in Advance.

Best Regards,


#4

This looks like the issue reported here.

Can you upgrade the 1.2.2 to a newer version?