Anciennes révisionsLiens de retourExporter en PDFHaut de page Share via Share via... Twitter LinkedIn Facebook Pinterest Telegram WhatsApp Yammer RedditDerniers changementsSend via e-MailImprimerPermalien × #! /bin/sh ############################################################################ # Copyright (C) 2008 by fradeff@akademia.ch # # # # This program is free software; you can redistribute it and#or modify # # it under the terms of the GNU General Public License as published by # # the Free Software Foundation; either version 2 of the License, or # # (at your option) any later version. # # # # This program is distributed in the hope that it will be useful, # # but WITHOUT ANY WARRANTY; without even the implied warranty of # # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # # GNU General Public License for more details. # # # # You should have received a copy of the GNU General Public License # # along with this program; if not, write to the # # Free Software Foundation, Inc., # # 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. # ############################################################################ # Usage: # mysqldumplocal.sh # sauvegarder toutes les bases MySQL sauf certaines # Required: # mysqldump, awk, gzip # source http://lists.nyphp.org/pipermail/talk/2004-October/012361.html # Adapted FR, fradeff@akademia.ch, radeff.red # History 1 octobre 2008, created FR ############ login=root #root login mysql password=xxx #passwd mysql memoire=30 #the number of days for the backup #path to mysql data directory mysql_dir=/var/lib/mysql #on debian #mysql_dir=/usr/local/mysql/data #on unix #path to backup mysql_backup=/home/radeff/backup/mysql #local #on unix #db to excludes test=cake_test test1=achats_dinf clear #find the db and exclude somes ls -al $mysql_dir | grep ^d | egrep -v '\.[\.]?' | grep -v $test | grep -v $test1 | awk '{print $8}' | while read i #begin loop on results do #dump db, name prededed by date, extension sql echo "mysqldump $i > $mysql_backup/$(date +'%Y%m%d_%Hh%M')_$i.sql" mysqldump -u $login -p$password $i > $mysql_backup/$(date +'%Y%m%d_%Hh%M')_$i.sql #zip the backups gzip $mysql_backup/$(date +'%Y%m%d_%Hh%M')_$i.sql done #end loop on results #destroy backups older than memoire days find $mysql_backup -mtime +$memoire -name "*.gz" -type f -exec rm {} \; echo "Backup OK on all MySQL requested DB's" # info/mysqldumplocal.sh.txt Dernière modification : 2018/07/18 09:46de radeff S'identifier