If you manage several pfSense boxes you might find it useful to have automated backups easily available. This pfSense FtpBackup package allows you to set up scheduled (daily, weekly or monthly) backup to your FTP server. Continue reading
#!/bin/bash prefix=mysql suffix=$(date +%F).sql filename=$prefix.$suffix mysqldump –opt -uroot -pxxx –all-databases > /backup/mysql/$filename cd /backup/mysql tar -cvf $filename.tar $filename gzip $filename.tar chown root:root /backup/mysql/$filename.tar.gz chmod 600 /backup/mysql/$filename.tar.gz rm $filename #SUBJECT=”MySQL Dump completed” #EMAIL=”my@email.com” #EMAILMESSAGE=”$filename created” #echo $EMAILMESSAGE | /bin/mail -s “$SUBJECT” … Continue reading