Known Issue - 25.10.4 - Question - How to backup and restore the old InfluxDB data?

[PASGT]

Problem
Since Firmware 25.10.4 there is the known issue with the TEDAPI access. Documented across the site.

I have therefore followed the instructions for creating a dual NIC computer with Wifi directly connected to the PW3 Wifi.
This all works great.

EDIT: 3 hours later....
I've got it working and have successfully imported the historic data.
Steps to make it work:

1. Follow Raspberry Pi Setup #607 - STOP Before the "Install Powerwall Dashboard" Step.
2. Follow: https://github.com/jasonacox/Powerwall-Dashboard/tree/main/backups to Take and Restore a backup - STOP before running the final ./setup.sh command.
3. You MUST Change Owner of the Powerwall-Dashboard to the current user - e.g. "sudo chown -R [USER] Powerwall-Dashboard"
4. Now run ./setup.sh command.
5. Your logins and passwords for Graphana etc will all be as they were in the backup.

Old Information
_However - I've (obviously) not got my historic data as it is a fresh install on a Raspberry Pi 4.

How do I backup and then restore JUST the InfluxDB element to have my past year's data?

I do NOT want to do the full backup and restore of the entire dashboard as I presume it won't work due to my previous install being on Ubuntu and the new one being on the Pi._

[jasonacox]

Hi @PASGT that's an interesting scenario. Basically you need to export just the old data, copy it to the new host, and then import just that new data.

CAUTION: This is an untest approach and suggestion only. I have not attempted this, so use and test with caution (and always do backups)

On Old Source Host (Export)

#!/bin/bash

DB_NAME="powerwall"
CONTAINER_NAME="influxdb"
EXPORT_DIR="/tmp/influxdb_export"
START_TIME="1970-01-01T00:00:00Z"
END_TIME="$(date -u +%Y-%m-%dT%H:%M:%SZ)"
RET_POLICIES=("raw" "autogen" "strings" "pwtemps" "vitals" "kwh" "daily" "monthly" "grid" "pod" "alerts" "fans")

mkdir -p "$EXPORT_DIR"

for RP in "${RET_POLICIES[@]}"; do
    SHARD_DIR="/var/lib/influxdb_export/$RP"
    echo "Running export for $DB_NAME.$RP inside container..."
    docker exec "$CONTAINER_NAME" mkdir -p "$SHARD_DIR"
    docker exec "$CONTAINER_NAME" influx_inspect export \
        -database "$DB_NAME" \
        -retention "$RP" \
        -start "$START_TIME" \
        -end "$END_TIME" \
        -out "$SHARD_DIR" \
        -datadir /var/lib/influxdb
    # Copy data from container to host
    docker cp "$CONTAINER_NAME":"$SHARD_DIR" "$EXPORT_DIR/$RP"
done

echo "Export complete. Transfer $EXPORT_DIR to the destination host."

Transfer the export:

scp -r /tmp/influxdb_export user@newhost:/tmp/

On Destination Host (Import)

#!/bin/bash

CONTAINER_NAME="influxdb"
IMPORT_DIR="/tmp/influxdb_export"
RET_POLICIES=("raw" "autogen" "strings" "pwtemps" "vitals" "kwh" "daily" "monthly" "grid" "pod" "alerts" "fans")

for RP in "${RET_POLICIES[@]}"; do
    SHARD_DIR_HOST="$IMPORT_DIR/$RP"
    SHARD_DIR_CONTAINER="/var/lib/influxdb_import/$RP"
    if [ -d "$SHARD_DIR_HOST" ]; then
        echo "Copying $RP to container..."
        docker cp "$SHARD_DIR_HOST" "$CONTAINER_NAME":"$SHARD_DIR_CONTAINER"
        echo "Running import for $RP inside container..."
        docker exec "$CONTAINER_NAME" influx_inspect import \
            -datadir /var/lib/influxdb \
            -path "$SHARD_DIR_CONTAINER"
    else
        echo "Skipping $RP (no export found)"
    fi
done

echo "Import complete."