Re: Backup MySQL off topic
| From: | Victor M. Varela | 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