You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 

29 lines
1.1 KiB

# Backup date
today=$(date "+%Y_%m_%d-%H_%M_%S")
echo "Current date: $today"
# build up filename
# destination folder (change to your own needs)
BACKUP_FOLDER=/tmp
file_name=$BACKUP_FOLDER/bkup_nc
new_name=$file_name-$today.sql
echo "Backup file name: " "$new_name"
#sudo docker exec `sudo docker container ls | grep mysql_gogs | cut -f1 -d' '` /usr/bin/mysqldump -u root --password=Dsa-0213 gogs > $new_name
sudo kubectl --kubeconfig /home/creylopez/.kube/config exec `kubectl --kubeconfig /home/creylopez/.kube/config get pod -n nextcloud|grep mysql|cut -f1 -d' '` -n nextcloud -- /usr/bin/mysqldump --column-statistics=0 -u root --password=Dsa-0213 nextcloud_db > $new_name
message="Backup stored "$today
sudo zip $new_name.zip $new_name
#sudo -u creylopez mail -s "Nextcloud backup finished" "creylopez@yahoo.es" -a $new_name.zip
#sudo -u creylopez cat $new_name | mail -s "Nextcloud backup finished" "creylopez@yahoo.es"
sudo -u creylopez echo "Nextcloud backup adjunto" |mail -s "Backup de nextcloud" creylopez@yahoo.es -A $new_name.zip
#sudo rm $new_name.*