http://en.juantxu.net/ Wed, 08 Sep 2010 12:45:43 +0200 FeedCreator 1.7.2-ppt DokuWiki http://en.juantxu.net/lib/images/favicon.ico http://en.juantxu.net/ http://en.juantxu.net/doku.php/mysql/backup?rev=1222773804&do=diff #!/bin/bash # ## ------ VARIABLES DE CONFIGURACION ----## # HOST=localhost USER=root PASS=TU_PASSWORD BACKUP_DIR=/TU/DIRECTORIO/DE/BACKUP DIA=`date | cut -d' ' -f1`; ## ----- FIN DE LA CONFIGURACION -------- ## if [ ! -d $BACKUP_DIR ]; then mkdir -p $BACKUP_DIR fi # Backup de MySQL MYSQL_DBS=$(mysqlshow -h $HOST -u $USER -p$PASS | awk ' (NR > 2) && (/[a-zA-Z0-9]+[ ]+[|]/) && ( $0 !~ /mysql/) { print $2 }'); for DB in $MYSQL_DBS ; do echo "* Haciendo un backup de los datos MySQL … mysql Tue, 30 Sep 2008 13:23:24 +0200