<?php
#########################################################
///////////////////////////////////////
//------------ Accunt Setting ------------
$db_location = "localhost";
$db_username = "root";
$db_password = "";
$db_name = "DataBase Name";
//--------------------------------------
@ $db = new mysqli ($db_location,$db_username,$db_password,$db_name);
if (mysqli_connect_errno()){exit('No Connect To Database !!??');}
$result = $db->query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'");
///////////////////////////////////////
#########################################################
set_time_limit(0);
$time=date(" M j, Y ").' at '.date(" G:i A ");
$query="SELECT @@version;";
$result = $db->query($query);
$num_result = $result->num_rows;
$row = $result->fetch_assoc();
$version=$row['@@version'];
///////////////////////////////////////
$query="SELECT user();";
$result = $db->query($query);
$num_result = $result->num_rows;
$row = $result->fetch_assoc();
$userdb=$row['user()'];
///////////////////////////////////////
$Backup="
-- PhpGrp.Com [ Army.Hidden ]
-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
-- http://www.Parsa-Net.Com
--
-- Host: $db_location
-- Generation Time: $time
-- Server version: `$version`
-- Server User: `$userdb`
-- PHP Version: 5.2.0
--
-- Database: `$db_name`
--
-- --------------------------------------------------------
";
$query = "SHOW TABLES ;";
$result = $db->query($query);
$num_result = $result->num_rows;
for ($i=0 ; $i < $num_result ; $i++)
{
$row = $result->fetch_assoc();
$table=$row['Tables_in_'.$db_name];
$query_op = "OPTIMIZE TABLE $table;";
$result_op = $db->query($query_op);
$Backup.="
--
-- Table structure for table `$table`
--
";
$query1 = "SHOW CREATE TABLE $table";
$result1 = $db->query($query1);
$num_result1 = $result1->num_rows;
for ($i1=0 ; $i1 < $num_result1 ; $i1++)
{
$row1 = $result1->fetch_assoc();
$Backup.=$row1['Create Table'].";\n\n";
$query2 = "SELECT * FROM $table";
$result2 = $db->query($query2);
$num_result2 = $result2->num_rows;
IF ($num_result2){
$Backup.="
--
-- Dumping data for table `$table`
--
";
$Backup.="INSERT INTO `$table` VALUES \n";
for ($i2=1 ; $i2 <= $num_result2 ; $i2++)
{
$row2 = $result2->fetch_assoc();
$Backup.="(";
$query3 = "SHOW COLUMNS FROM $table";
$result3 = $db->query($query3);
$num_result3 = $result3->num_rows;
for ($i3=0 ; $i3 < $num_result3 ; $i3++)
{
$row3 = $result3->fetch_assoc();
$Backup.="'".$row2[$row3['Field']]."',";
}
IF($i2==$num_result2){
$Backup.=");\n";
}else{
$Backup.="),\n";
}
}
}
}
}
$Backup=str_replace(',)',')',$Backup);
$name=$db_name.".sql";
$H = fopen($name,"w");
if(fwrite($H,$Backup)){
echo 'Backup Was Created';
}
fclose($H);
?>
