Akshay Khot akshayKhot

🎯

Focusing

Ruby on Rails developer based in Victoria, BC.

akshayKhot / database_backup.rb

Last active February 17, 2025 14:05

A Ruby script to take SQLite database backup from a docker container running on a remote server

	# lib/database_backup.rb

	class DatabaseBackup
	SERVER_IP = "your-server-ip"
	SERVER_USER = "root"
	CONTAINER_NAME = "your-app-web"
	LOCAL_BACKUP_DIR = "/path/to/backups"
	RETENTION_DAYS = 30

	def self.run

akshayKhot / backup.sh

Created February 17, 2025 14:02

Shell Script for SQLite Database Backup

	#!/bin/bash

	# Configuration
	SERVER_IP="your-server-ip-address"
	SERVER_USER="root"
	CONTAINER_NAME="your-app-web"
	LOCAL_BACKUP_DIR="/path/to/backups"
	RETENTION_DAYS=30
	LOG_FILE="${LOCAL_BACKUP_DIR}/backup.log"