Personal
/
mariadb-bak
1
0
Bifurcation 0
Code Tickets 0 Demandes d'ajout 0 Versions 0 Wiki Activité
A simple bash script to backup MariaDB.
Vous ne pouvez pas sélectionner plus de 25 sujets Les noms de sujets doivent commencer par une lettre ou un nombre, peuvent contenir des tirets ('-') et peuvent comporter jusqu'à 35 caractères.
1 Commit
1 Branche
36KB
Branche: master
Branches Tags
${ item.name }
Créer la branche ${ searchTerm }
de 'master'
${ noResults }
mariadb-bak/mariadb-bak.sh

45 lignes
1.7KB
Brut Lien permanent Annotations Historique 

  1. #!/bin/bash

  2. 

  3. export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

  4. BAK_DIR=/var/backups/mysql

  5. LOG_DIR=/var/log/mysql

  6. 

  7. echo "Starting Backup" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  8. echo "---------" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  9. 

  10. xtrabackup --backup --target-dir=$BAK_DIR >> \

  11.     $LOG_DIR/mysql-bak-$(date +%F).log 2>&1 || \

  12.     echo "Backup failed with exit value $?" >> \

  13.     $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  14. 

  15. echo "Backup Finished" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  16. echo "---------" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  17. echo "" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  18. 

  19. echo "Starting Prepare #1" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  20. echo "---------" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  21. 

  22. xtrabackup --prepare --target-dir=$BAK_DIR >> \

  23.     $LOG_DIR/mysql-bak-$(date +%F).log 2>&1 || \

  24.     echo "Prepare #1 failed with exit value $?" >> \

  25.     $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  26. 

  27. echo "Prepare #1 Finished" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  28. echo "---------" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  29. echo "" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  30. 

  31. echo "Starting Prepare #2" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  32. echo "---------" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  33. 

  34. xtrabackup --prepare --target-dir=$BAK_DIR >> \

  35.     $LOG_DIR/mysql-bak-$(date +%F).log 2>&1 || \

  36.     echo "Prepare #1 failed with exit value $?" >> \

  37.     $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  38. 

  39. echo "Prepare #2 Finished" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  40. echo "---------" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  41. echo "" >> $LOG_DIR/mysql-bak-$(date +%F).log 2>&1

  42. 

  43. # Delete logs older than 30 days

  44. find $LOG_DIR -name "mysql-bak-*" -mtime +30 -delete