Re: Backup MySQL off topic

From: Date: Fri, 06 Oct 2000 07:22:46 +0000
Subject: Re: Backup MySQL off topic
Groups: php.general.es 
Request: Send a blank email to general-es+get-2210@lists.php.net to get a copy of this message
Alex Verstraeten <alex@quad.com.ar> dijo: > ------------- aca empieza -------------- > #!/usr/bin/perl > > # CONFIGURACION > $MYSQL = "/usr/local/bin/mysql"; > $MYSQLDUMP = "/usr/local/bin/mysqldump"; > $DB_USER = "root"; > $DB_PASS = "secret"; > $DB_HOST = "localhost"; > $DIR = "/usr/backup/mysql"; > > # Backup de las bases > @databases = `/bin/echo "show databases" | $MYSQL -u $DB_USER -p$DB_PASS | > grep -v "^Database"`; > foreach $db (@databases){ > chop($db); > system("$MYSQLDUMP -u $DB_USER -p$DB_PASS -l $db > $DIR/$db.sql"); > } > ---------- aca termina------------------ Me ha gustado tanto el script que he hecho una version identica en PHP: --- a quien pueda interesar --- #!/usr/local/bin/php -f <?php # CONFIGURACION $MYSQL = "/usr/local/bin/mysql"; $MYSQLDUMP = "/usr/local/bin/mysqldump"; $DB_USER = "root"; $DB_PASS = "secret"; $DB_HOST = "localhost"; $DIR = "/usr/backup/mysql"; # Backup de las bases $databases = popen("/bin/echo 'show databases' | $MYSQL -u $DB_USER -p$DB_PASS | grep -v '^Database'", "r"); while ($db = trim(fgets($databases,4000))) { exec("$MYSQLDUMP -u $DB_USER -p$DB_PASS -l $db > $DIR/$db.sql"); } pclose($f); ?> --- eso es todo amigos --- -- Programmer Integracion de Metodologias y Sistemas (Spain) http://www.netims.com linux user: #45510

« previous php.general.es (#2210) next »