This page was exported from GTUTO [ https://www.gtuto.com ]

Export date:Thu Oct 16 18:09:38 2025 / +0000 GMT

___________________________________________________


Title: Sauvegarde distante

---------------------------------------------------



#! /bin/sh 
# sauvegarde de /home, /etc/ et de toutes les bases mysql en tar.gz d'un serveur distant vers mon serveur local
# prévoir de la place dans /tmp sur le serveur distant pour toutes les bases en tar.gz


rsync -avz monserveur.com:/home/ /home/sav/monserveur.com/
rsync -avz monserveur.com:/etc /home/sav/monserveur.com/

ssh monserveur.com 'mysql --skip-column-names -mariauser -pmariapass -e "show databases " | while read dbname; do mysqldump --lock-all-tables -mariauser -pmariapass "$dbname" | gzip> /tmp/"$dbname".sql.gz; done;'

rsync -avz monserveur.com:/tmp/*.sql.gz /home/sav/monserveur.com/mysql/


---------------------------------------------------


Images: 

---------------------------------------------------




---------------------------------------------------


Post date: 2025-10-15 07:22:43

Post date GMT: 2025-10-15 07:22:43

Post modified date: 2025-10-15 20:09:54

Post modified date GMT: 2025-10-15 20:09:54



____________________________________________________________________________________________


Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com