<?php
$backupfilename = 'sample_file_name'; //dump filename
if(isset($_POST['submitted']))
{
function backup_tables($host,$user,$pass,$name,$backupfilename,$tables = '*')
{
$link = mysql_connect($host,$user,$pass,$backupfilename);
mysql_select_db($name,$link);
if($tables == '*')
{
$tables = array();
$result = mysql_query('SHOW TABLES');
while($row = mysql_fetch_row($result))
{
$tables[] = $row[0];
}
}
else
{
$tables = is_array($tables) ? $tables : explode(',',$tables);
}
$return='';
foreach($tables as $table)
{
$result = mysql_query('SELECT * FROM '.$table);
$num_fields = mysql_num_fields($result);
$return.= 'DROP TABLE '.$table.';';
$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
$return.= "\n\n".$row2[1].";\n\n";
for ($i = 0; $i < $num_fields; $i++)
{
while($row = mysql_fetch_row($result))
{
$return.= 'INSERT INTO '.$table.' VALUES(';
for($j=0; $j<$num_fields; $j++)
{
$row[$j] = addslashes($row[$j]);
$row[$j] = preg_replace("#\n#","\\n",$row[$j]);
if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; }
if ($j<($num_fields-1)) { $return.= ','; }
}
$return.= ");\n";
}
}
$return.="\n\n\n";
}
$handle = fopen($backupfilename . '.sql','w+');
fwrite($handle,$return);
fclose($handle);
}
$datengayon=date('Y-m-d H:i:s');
$backup_user=$_SESSION['user'];
$backup_directory=$backupfilename . '.sql';
$q="insert into backuplog (backup_date, backup_user, backup_directory) values ('$datengayon','$backup_user', '$backup_directory')";
$r=mysqli_query($dbc, $q);
backup_tables(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME,$backupfilename); // supply the corresponding database credentials here
echo '<fieldset style="border: 2px solid #06c; width: 400px;">';
echo '<legend style="display: block; font: 16px Arial, Helvetica; font-weight: bold; color: #06c;">Database back-up status</legend>';
echo '<span style="display: block; font: 12px Arial, Helvetica; color: #f33; margin-left: 20px;">';
if($r)
{
echo 'Back-up process successful!';
}
else
{
echo 'Back-up process failed!';
}
echo '</span>';
echo '</fieldset>';
}
?>
balak ko lang po sana halimbawa marami na akong code mahaba na.. to check syntax error lang para mas mabilis makita kung ano ang mali. Free lang po ba ang gedit editor sir? nachecheck din po ba ang inyong syntax error?
po in advance sir.. 
