If an ethoscope device fails or you need to recover tracking data from an SD card, you can extract the MariaDB database and convert it to SQLite format using the tools provided here.

When Would You Need This?

• The ethoscope device is no longer functional
• The network backup failed and you need to recover data directly from the SD card
• You want to archive data from an SD card before reimaging it
• The ethoscope was running but the data was never synced to the node

Prerequisites

Before you begin, make sure you have:

1. A Linux computer (the node server or any Linux machine)

2. Docker installed and running

   # Check if Docker is running
   docker info
   
   # If not running, start it
   sudo systemctl start docker
   
   

3. An SD card reader to connect the ethoscope's microSD card

4. SQLite3 installed (usually pre-installed on most Linux systems)

   # Check if installed
   sqlite3 --version
   
   

Step-by-Step Instructions

Step 1: Remove the SD Card from the Ethoscope

1. Power off the ethoscope device completely
2. Carefully remove the microSD card from the Raspberry Pi
3. Insert the SD card into a card reader connected to your Linux computer

Step 2: Locate the SD Card Mount Point

When you insert the SD card, it should automatically mount. Find where it mounted:

# List mounted devices
lsblk

# Or check the /run/media directory (common on most Linux systems)
ls /run/media/$USER/