copyDrupalDB 720 B

123456789101112131415161718192021222324252627
  1. # Backup date
  2. today=$(date "+%Y_%m_%d-%H_%M_%S")
  3. echo "Current date: $today"
  4. # build up filename
  5. # destination folder (change to your own needs)
  6. BACKUP_FOLDER=/tmp
  7. file_name=$BACKUP_FOLDER/bkup_drupal
  8. new_name=$file_name-$today.sql
  9. echo "Backup file name: " "$new_name"
  10. sudo kubectl --kubeconfig /home/creylopez/.kube/config -n drupal exec `sudo kubectl --kubeconfig /home/creylopez/.kube/config get pod -n drupal | grep mysql | cut -f1 -d' '` -- /usr/bin/mysqldump -u root --password=Dsa-0213 drupaldb > $new_name
  11. message="Backup stored "$today
  12. zip $new_name.zip $new_name
  13. sudo -u creylopez echo "Copia terminada" | mail -s "Drupal backup finished" "creylopez@yahoo.es" -A $new_name.zip
  14. sudo rm $new_name*