ZALOHA MYSQL

[Pavel Benisek]

On Fri 10. of December 2004 13:59, Petr Vileta wrote:
> >> Ako njednoduchsie odzalohovat databzu mysql nejak pochopitelne aj
> >> pre laika.
> >
> > mysqldump - viz. dokumentace k MySQL.
>
> Proc to vsichni delaji tak slozite? :-)
> Ja na to pouzivam perlovsky skript:
tak ja delam to same PHP scriptem ...

#! /usr/bin/php -q
#
<?
// archive database

function write_m($text){
    $show_messages=0;

    if ($show_message!=0) {
        echo $text;
    }
}

$dir="/home/cesta/k/zaloham";

$myhostName="localhost";
$myuserName="root";
$myPW="heslo";


if ($db=@mysql_connect($myhostName,$myuserName,$myPW)){
    $query="show databases";
    $result = mysql_query($query,$db);
    while($data=mysql_fetch_array($result)){
        //echo $data[0]."\n";
        write_m($data[0].": dumping database ...\n");
        system("mysqldump -u".$myuserName." -p".$myPW." ".$data[0]."> ".
$dir."/".$data[0].".sql");

        write_m($data[0].": removing old version of archive ...\n");
        system("rm ".$dir."/".$data[0].".sql.bz2");

        write_m($data[0].": gzipping new database archive...\n\n");
        system("bzip2 -vq9 ".$dir."/".$data[0].".sql");
    }
}
write_m("Done\n\n");


-- 
Pavel Benisek