Jinsi ya Kutengeneza Automated Backups kwa Local Server
Automated backups ni muhimu kuhakikisha data yako haipotei kutokana na errors, hardware failure, au changes zisizotarajiwa. Kwa local server, unaweza kutumia bash scripts pamoja na cron jobs (Linux/Mac) au Task Scheduler (Windows) kufanya backups za database na files kwa automatic.
Mfano wa Bash Script kwa Linux/Mac:
#!/bin/bash
# Set variables
BACKUP_DIR="/home/user/backups"
DB_NAME="mydatabase"
DB_USER="root"
DB_PASS="password"
DATE=$(date +"%Y-%m-%d_%H-%M-%S")
# Create backup directory if not exists
mkdir -p $BACKUP_DIR
# Backup MySQL database
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_DIR/db_$DATE.sql
# Backup website files
tar -czf $BACKUP_DIR/www_$DATE.tar.gz /var/www/html/myapp
# Optional: Delete backups older than 7 days
find $BACKUP_DIR -type f -mtime +7 -delete
echo "Backup completed on $DATE"
Jinsi ya Ku-schedule Backup Automatic kwa Linux:
Fungua crontab editor:
crontab -e
Ongeza entry ya daily backup saa 2am:
0 2 * * * /home/user/scripts/backup.sh
Ufafanuzi:
mysqldump inafanya backup ya MySQL database.
tar -czf inachomeka na compress files za project.
find ... -mtime +7 -delete inahakikisha backups za zamani zinafutwa ili space isijazwe.
Kwa Windows, unaweza kutumia Task Scheduler ku-run script sawa.
🔗 Links Za Kujifunza Zaidi:
🌐 Faulink Official Website:
https://www.faulink.com/
📘 Jifunze Web Design & Programming (Tutorials / Mifumo):
https://www.faulink.com/excel_mifumo.php
📲 Piga / WhatsApp kwa msaada wa haraka:
https://wa.me/255693118509
Mfano wa Bash Script kwa Linux/Mac:
#!/bin/bash
# Set variables
BACKUP_DIR="/home/user/backups"
DB_NAME="mydatabase"
DB_USER="root"
DB_PASS="password"
DATE=$(date +"%Y-%m-%d_%H-%M-%S")
# Create backup directory if not exists
mkdir -p $BACKUP_DIR
# Backup MySQL database
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_DIR/db_$DATE.sql
# Backup website files
tar -czf $BACKUP_DIR/www_$DATE.tar.gz /var/www/html/myapp
# Optional: Delete backups older than 7 days
find $BACKUP_DIR -type f -mtime +7 -delete
echo "Backup completed on $DATE"
Jinsi ya Ku-schedule Backup Automatic kwa Linux:
Fungua crontab editor:
crontab -e
Ongeza entry ya daily backup saa 2am:
0 2 * * * /home/user/scripts/backup.sh
Ufafanuzi:
mysqldump inafanya backup ya MySQL database.
tar -czf inachomeka na compress files za project.
find ... -mtime +7 -delete inahakikisha backups za zamani zinafutwa ili space isijazwe.
Kwa Windows, unaweza kutumia Task Scheduler ku-run script sawa.
🔗 Links Za Kujifunza Zaidi:
🌐 Faulink Official Website:
https://www.faulink.com/
📘 Jifunze Web Design & Programming (Tutorials / Mifumo):
https://www.faulink.com/excel_mifumo.php
📲 Piga / WhatsApp kwa msaada wa haraka:
https://wa.me/255693118509