77 lines
1.8 KiB
Markdown
77 lines
1.8 KiB
Markdown
# 🧩 Database Restore Guide: Nextcloud + Immich
|
|
|
|
This guide explains how to restore database backups created by your automated scripts from compressed `.sql.gz` files.
|
|
|
|
---
|
|
|
|
## ✅ What You Need
|
|
|
|
- `.sql.gz` dump file (stored in `/mnt/backup_nvme/db_dumps/` or `/mnt/nc_data/db_dumps/`)
|
|
- Shell access to the relevant host/container
|
|
- Database credentials (stored in Bitwarden)
|
|
- Docker (Nextcloud) or LXC (Immich) access
|
|
|
|
---
|
|
|
|
## 🗃️ Restore Nextcloud DB (inside LXC 115)
|
|
|
|
### 1. Copy the desired dump file into the container
|
|
|
|
If restoring from PBS/B2:
|
|
|
|
```bash
|
|
scp nextcloud-2025-07-22.sql.gz root@192.168.1.50:/mnt/nc_data/db_dumps/
|
|
```
|
|
|
|
### 2. SSH into the Nextcloud container (LXC 115):
|
|
|
|
```bash
|
|
pct enter 115
|
|
```
|
|
|
|
### 3. Run the restore
|
|
|
|
```bash
|
|
cd /mnt/nc_data/db_dumps
|
|
gunzip nextcloud-2025-07-22.sql.gz
|
|
|
|
# Replace DB name/user as needed (see your env)
|
|
docker exec -i nextcloud-aio-database psql -U nextcloud -d nextcloud_database < nextcloud-2025-07-22.sql
|
|
```
|
|
|
|
---
|
|
|
|
## 🗃️ Restore Immich DB (from Proxmox04 via LXC 109)
|
|
|
|
### 1. Copy the dump to Proxmox04 (if pulled from B2):
|
|
|
|
```bash
|
|
rclone copy b2-pbs-encrypted:db_dumps/immich-2025-07-22.sql.gz /mnt/backup_nvme/db_dumps/
|
|
```
|
|
|
|
### 2. Run the restore from Proxmox04:
|
|
|
|
```bash
|
|
cd /mnt/backup_nvme/db_dumps
|
|
gunzip immich-2025-07-22.sql.gz
|
|
|
|
# Attach to container and restore
|
|
lxc-attach -n 109 -- runuser -u immich -- bash -c "psql -d immich < /mnt/backup_nvme/db_dumps/immich-2025-07-22.sql"
|
|
```
|
|
|
|
---
|
|
|
|
## 🧠 Tips
|
|
|
|
- Always test restores in a clone or sandbox container if possible
|
|
- After restore, confirm app behavior and log in to the web UI
|
|
- Back up `/opt/immich/.env` or Docker `.env` for full recovery context
|
|
- Use `pg_restore` instead of `psql` if using a binary format
|
|
|
|
---
|
|
|
|
Created: 2025-07-22\
|
|
Maintainer: chris.darrigo\@gmail.com\
|
|
Stored in: Gitea (`HomeLabDocs`)
|
|
|