| 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
