Creates MySQL dumps, archives files, encrypts them via GPG, and uploads them to a remote server via SFTP. Key features:
- MySQL : Saving databases.
- Archiving : Packing specified directories and files into tar.gz.
- Encryption : Data protection using GPG.
- Logging : All actions are recorded in a log file.
- Automation : Integration with cron for regular backups.
Tips:
- Do not store passwords in the script — use files with restricted access or environment variables.
- Test the script manually before adding it to cron.
Ideal for local servers where it’s important to preserve and protect data. Simplicity + reliability!
You can download it from GitHub: https://github.com/Struam/backup-full