| 123456789101112131415161718192021222324 |
- # 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_repostajes
- new_name=$file_name-$today.sql
- echo "Backup file name: " "$new_name"
- #sudo docker exec `sudo docker container ls | grep mysql_repostajes | cut -f1 -d' '` /usr/bin/mysqldump -u root --password=Dsa-0213 repostajes > $new_name
- sudo kubectl --kubeconfig /home/creylopez/.kube/config exec `kubectl --kubeconfig /home/creylopez/.kube/config get pod -n repostajes|grep mysql|cut -f1 -d' '` -n repostajes -- /usr/bin/mysqldump --column-statistics=0 -u root --password=Dsa-0213 automoviles > $new_name
- message="Backup stored "$today
- sudo -u creylopez cat $new_name | mail -s "Repostajes backup finished" "creylopez@yahoo.es"
- sudo rm $new_name
|
