<?php
header('Content-disposition: attachment; filename=veritabani.sql');
header('Content-type: unknown/unknown');
$vthost="localhost";
$vtkullanici="db_kullanıcı_adı";
$vtsifre="şifreniz";
$vtadi="db_veritabani";
$baglan=mysql_connect($vthost,$vtkullanici,$vtsifr e);
$sec=mysql_select_db($vtadi,$baglan);
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET COLLATION_CONNECTION = 'utf8_turkish_ci'");
$tablolar=mysql_list_tables($vtadi);
$tablosayisi=mysql_num_rows($tablolar);
for ($a=0;$a<$tablosayisi;$a++)
{
$row=mysql_fetch_row($tablolar);
$tablename=$row[0];
$crtable=mysql_query("show create table $tablename");
$tmpres = mysql_fetch_row($crtable);
echo "\n\n";
echo $tmpres[1].";";
echo "\n\n";
$alanlar=mysql_query("select * from `$tablename`");
$alansayisi=mysql_num_fields($alanlar);
$nr=mysql_num_rows($alanlar);
for ($c=0;$c<$nr;$c++)
{
echo "INSERT INTO `$tablename` VALUES (";
$row=mysql_fetch_row($alanlar);
for ($d=0;$d<$alansayisi;$d++)
{
$data=strval($row[$d]);
echo "'".addslashes($data)."'";
if ($d<($alansayisi-1))
{
echo ", ";
}
}
echo ");\n";
}
}

echo "\r\n\r\n\r\n### yedek alındı ###";
?>