name	memorains-db-backup
description	Back up the memorains production database and download the dump to the local backups/ directory. Use when the user wants to back up, dump, export, or download the memorains database, or mentions database backup, DB snapshot, or saving the database.

Memorains DB Backup

Back up the remote MariaDB database and download the compressed dump to the local backups/ directory.

Prerequisites

SSH access to the target server — if the user didn't specify which server, ask
Server must have podman running with the reno_note_mariadb container

Determine the target host

If the user already specified a host, use it. Otherwise, ask: "Which server should I back up?"

In all commands below, replace <HOST> with the actual hostname.

Backup Steps

1. Dump the database

ssh <HOST> "podman exec reno_note_mariadb mariadb-dump -u doc -p123456 document > /tmp/memorains_backup_<HOST>_\$(date +%Y%m%d_%H%M%S).sql"

2. Compress the dump

ssh <HOST> "ls -t /tmp/memorains_backup_<HOST>_*.sql | head -1 | xargs gzip -f && ls -lh /tmp/memorains_backup_<HOST>_*.sql.gz | tail -1"

3. Download to local backups/ directory

scp <HOST>:/tmp/memorains_backup_<HOST>_<TIMESTAMP>.sql.gz <PROJECT_ROOT>/backups/

If the download is slow (file may be 50-80MB), add -o ConnectTimeout=30 -o ServerAliveInterval=15 to the scp command and use a generous timeout.

4. Verify integrity

gzip -t <PROJECT_ROOT>/backups/memorains_backup_<HOST>_<TIMESTAMP>.sql.gz && echo "✅ Backup complete and verified"

5. Clean up remote temp file

ssh <HOST> "rm /tmp/memorains_backup_<HOST>_*.sql.gz"

Database Connection Details

Parameter	Value
Container	`reno_note_mariadb`
Database	`document`
User	`doc`
Password	`123456`

These come from docker-compose.yml in the deployed package.

Output

A timestamped, gzip-compressed SQL dump saved in <PROJECT_ROOT>/backups/:

backups/memorains_backup_<HOST>_20260628_152430.sql.gz

Restore (if needed)

gunzip < memorains_backup_<HOST>_<TIMESTAMP>.sql.gz | podman exec -i reno_note_mariadb mariadb -u doc -p123456 document

name	memorains-db-backup
description	Back up the memorains production database and download the dump to the local backups/ directory. Use when the user wants to back up, dump, export, or download the memorains database, or mentions database backup, DB snapshot, or saving the database.