script buat backup

<?php
$dsn  = array(
    'username' => 'root',
    'password' => '',
    'host' => 'localhost',
    'database' => 'work_sejahtera4'
);
$max=2591;
/*
Ganti setting di atas dengan setting yg kamu gunakan
perhatian disini belum termasuk membatasi berapa kb yg boleh!!
*/

$page=intval($_GET[page]);
$iTable=intval($_GET[iTable]);
$_GET[iFile]?$iFile=intval($_GET[iFile])+1:$iFile=100;
$done=1;
/*
script ini tidak menggunakan PEAR
*/
$con=mysql_connect($dsn['host'], $dsn['username'], $dsn['password']) or
    die(mysql_error());

$sql="SHOW TABLES FROM ".$dsn['database'];
$res=mysql_query($sql) or die(mysql_error());
$s='<ol>';
while($r=mysql_fetch_array($res))
{
    $s.="<li>".$r[0];
    $aTable[]=$r[0];
}
$s.="</ol>";
//echo $s;
unset($s);
$table=$aTable[$iTable];
$sql="select * from ".$dsn['database'].".`$table` limit  $page ,$max";
$res=mysql_query($sql) or die(mysql_error().$sql);
echo "<br>$sql";
$tot=mysql_num_rows($res);
while($r=mysql_fetch_array($res))
{
    $s.="INSERT INTO `$table` VALUES\n ('".addslashes($r[0])."'";
            //die('n='.count($rTab));
    for($i2=1;$i2<count($r );$i2++){
        $s.="\t,'".addslashes($r[$i2])."'";
    }

            $s.=");\n
[br]";
    $page++; $iSql++;
}



    if($iSql<$max)
    {
            $sql="REPAIR TABLE `$table` ";
            $res=mysql_query($sql)  ;
            echo "<br>repair $table";

    }
/*
tulis
*/
    if($s)
    {
        $i++;
        $filename="db\back_$iFile.sql";
        if (!$handle = fopen($filename, 'w')) {
             echo "Cannot open file ($filename)";
             exit;
        }

        // Write $somecontent to our opened file.
        if (fwrite($handle, $s) === FALSE) {
            echo "Cannot write to file ($filename)";
            exit;
        }

        fclose($handle);
        unset($s);

    }
/*
Final check
*/
if($tot==0){
    $page=0;
    $iTable++;
}

if($err)
{
    die($err);
}


$url="?page=$page&iTable=$iTable&iFile=$iFile";

$s2='<script>window.location="'.$url.'" ;</script>';
$s2.=date("H:i:s");
if($done)
    print $s2;

die('stop');
die($s);