Note: I hope this is in the right section, if not, please let me know and I will repost. Hi all, I have created two little scripts to server a task that I needed to be automated. I wanted a way to back up specific folders on each of my ISPConfig servers. I wanted the backups to include all my client's SQL databases, and I wanted it to be daily, with tar.gz archives of the last seven days, the last 5 weeks and the last 6 months. I created two scripts. 1. SQLDumps I put this script in /var/sqldumps. I gave it "included on the git copy by default" the databases I don't need backed up, in the case of a ISPConfig 3.2 install. In the script file you will see an array, you can edit the list there. It is commented to indicate where to do it. I run it each day at 8pm via crontab. 2. daily-backup For each of my servers, I run on a local server here at my office, a copy of the script, one folder per server, a copy in each folder. Again, I have used an array to list the folders to backup. You will see by default it contains the sqldumps location as well as vmail, mail, www etc. I set it run 4 times a day for each server, as I do have power issues here in my country. If it runs it will check if a backup was completed on the same day, if so, it will skip. Each time it runs, it only rsyncs the changes. First time will take a while though. It does need rsync, tar, gzip and an SSH key pair to work. The idea is multi forked. 1, I have daily/weekly/monthly backups, so if a client calls and cries, oh he accidentally deleted some important webpage, email etc, I can recover it. 2. I have a local back up that is off site, so if anything happens with regards to the datacenter/cloud provider/whatever, I can quickly get my clients back up and running. 3. I wanted to be notified via Telegram when a backup is completed, and receive some basics stats about the backup. (Telegram API is needed - but it's free so don't worry). It's important to note, a back up on the same VM is NOT A BACKUP!!! If the VM goes down, so does the backup. Offsite is always king. You can check it out at: https://git.zaks.web.za/thisiszeev/linux-server-tools Due to power issues in my country, the server may be down. Just wait 2 hours and try again. I am working towards getting some new batteries for my inverter. I have a lot of other useful server scripts that I am going to add to that same repository over time, so check back often. But I will post here as well when I add/update. Any feedback, positive and negative, is more than welcome. Just no flames, I burn easy.
Better be in tips / tricks board though I would prefer the scripts or their code are attached together here instead of a git link that is down / will be down.
