Backup and Recovery

# 1. Stop server
machadmin -s

# 2. Backup database
machadmin -b /backup/machbase_backup_20251010

# 3. Start server
machadmin -u

#!/bin/bash
# daily_backup.sh

BACKUP_DIR="/backup/machbase"
DATE=$(date +%Y%m%d)
BACKUP_PATH="$BACKUP_DIR/backup_$DATE"

# Create backup directory
mkdir -p $BACKUP_DIR

# Stop server
machadmin -s

# Backup
machadmin -b $BACKUP_PATH

# Start server
machadmin -u

# Verify backup
if [ -d "$BACKUP_PATH" ]; then
    echo "Backup successful: $BACKUP_PATH"
    # Compress backup
    tar -czf ${BACKUP_PATH}.tar.gz -C $BACKUP_DIR backup_$DATE
    rm -rf $BACKUP_PATH
else
    echo "Backup failed!" | mail -s "Backup Error" admin@company.com
fi

# Remove old backups (keep last 7 days)
find $BACKUP_DIR -name "backup_*.tar.gz" -mtime +7 -delete

# Edit crontab
crontab -e

# Add daily backup at 2 AM
0 2 * * * /opt/scripts/daily_backup.sh >> /var/log/machbase_backup.log 2>&1

# 1. Stop server (if running)
machadmin -s

# 2. Remove existing database
rm -rf $MACHBASE_HOME/dbs/*

# 3. Restore from backup
machadmin -r /backup/machbase_backup_20251010

# 4. Start server
machadmin -u

# 5. Verify
machsql -f - <<EOF
SHOW TABLES;
SELECT COUNT(*) FROM sensors;
EOF

# Extract backup
tar -xzf /backup/backup_20251010.tar.gz -C /tmp

# Restore
machadmin -s
rm -rf $MACHBASE_HOME/dbs/*
machadmin -r /tmp/backup_20251010
machadmin -u

# Cleanup
rm -rf /tmp/backup_20251010

# 1. Mount database (creates consistent snapshot)
machadmin -mount /backup/mount_point

# 2. Copy database files
cp -r $MACHBASE_HOME/dbs /backup/online_backup_20251010

# 3. Unmount
machadmin -unmount /backup/mount_point

# Export single table
machsql -s localhost -u SYS -p MANAGER -f - -o sensors_backup.csv -r csv <<EOF
SELECT * FROM sensors;
EOF

# Export with time range
machsql -s localhost -u SYS -p MANAGER -f - -o sensors_recent.csv -r csv <<EOF
SELECT * FROM sensors DURATION 7 DAY;
EOF

#!/bin/bash
# export_tables.sh

BACKUP_DIR="/backup/csv"
DATE=$(date +%Y%m%d)

mkdir -p $BACKUP_DIR

# Export tables
for table in sensors logs devices; do
    echo "Exporting $table..."
    machsql -i -f - -o "$BACKUP_DIR/${table}_${DATE}.csv" -r csv <<EOF
SELECT * FROM $table;
EOF
done

# Compress exports
tar -czf $BACKUP_DIR/csv_backup_${DATE}.tar.gz -C $BACKUP_DIR *_${DATE}.csv
rm $BACKUP_DIR/*_${DATE}.csv

echo "CSV backup complete: $BACKUP_DIR/csv_backup_${DATE}.tar.gz"

# Import CSV data
machloader -t sensors -d csv -i sensors_backup.csv

#!/bin/bash
# incremental_backup.sh

BACKUP_DIR="/backup/machbase"
DAY_OF_WEEK=$(date +%u)  # 1=Monday, 7=Sunday

if [ $DAY_OF_WEEK -eq 7 ]; then
    # Sunday: Full backup
    echo "Performing full backup..."
    machadmin -s
    machadmin -b $BACKUP_DIR/full_$(date +%Y%m%d)
    machadmin -u
else
    # Weekday: CSV export
    echo "Performing incremental backup..."
    machsql -i -f - -o $BACKUP_DIR/incremental_$(date +%Y%m%d).csv -r csv <<EOF
    SELECT * FROM sensors WHERE _arrival_time >= SYSDATE - 1;
    EOF
fi

# Check backup directory exists
ls -lh /backup/machbase_backup_20251010

# Check backup size (should not be too small)
du -sh /backup/machbase_backup_20251010

# Test restore to temporary location
TEST_DIR="/tmp/test_restore"
mkdir -p $TEST_DIR
machadmin -r /backup/machbase_backup_20251010 -d $TEST_DIR
ls -lh $TEST_DIR
rm -rf $TEST_DIR

# Check CSV file
head -10 sensors_backup.csv
wc -l sensors_backup.csv

# Verify column count
awk -F',' '{print NF}' sensors_backup.csv | sort -u

# 1. Install Machbase
wget http://machbase.com/dist/machbase-xxx.tgz
tar xzf machbase-xxx.tgz
export MACHBASE_HOME=$(pwd)/machbase_home
export PATH=$MACHBASE_HOME/bin:$PATH

# 2. Restore from backup
machadmin -r /backup/machbase_backup_20251010

# 3. Start server
machadmin -u

# 4. Verify data
machsql -f - <<EOF
SHOW TABLES;
SELECT COUNT(*) FROM sensors;
SELECT MAX(_arrival_time) FROM sensors;
EOF

# 5. Test application connections

# Monthly restore test
# Restore to test environment and verify

# Cron schedule
0 2 * * * /opt/scripts/daily_backup.sh  # Daily at 2 AM
0 3 * * 0 /opt/scripts/weekly_backup.sh  # Weekly on Sunday

# Check backup logs
tail -50 /var/log/machbase_backup.log

# Alert on failure
if ! grep -q "Backup successful" /var/log/machbase_backup.log; then
    echo "Backup failed!" | mail -s "Alert" admin@company.com
fi

# Dedicated backup disk
/dev/sdb1 → /backup

# Mount in /etc/fstab
/dev/sdb1  /backup  ext4  defaults  0  2

# Sync to remote server
rsync -avz /backup/machbase/ backup-server:/backups/machbase/

# In backup script
tar -czf backup_${DATE}.tar.gz backup_${DATE}
rsync -avz backup_${DATE}.tar.gz backup-server:/backups/

# Upload to S3
aws s3 cp backup_${DATE}.tar.gz s3://my-backup-bucket/machbase/

# In backup script
tar -czf /tmp/backup_${DATE}.tar.gz -C /backup backup_${DATE}
aws s3 cp /tmp/backup_${DATE}.tar.gz s3://my-backup-bucket/machbase/
rm /tmp/backup_${DATE}.tar.gz

# Use ionice to reduce I/O priority
ionice -c3 machadmin -b /backup/machbase

# Use nice to reduce CPU priority
nice -n 19 machadmin -b /backup/machbase

# Ensure server is stopped
machadmin -s
sleep 5
machadmin -e  # Should show "not running"
machadmin -b /backup/path

# Check backup integrity
ls -lh /backup/machbase_backup

# Verify backup directory structure
tree /backup/machbase_backup

# Check disk space
df -h $MACHBASE_HOME

# Check space before backup
df -h /backup

# Clean old backups
find /backup -name "backup_*" -mtime +7 -delete