PHP backup mysql database (joomla database can be used directly, other databases can be slightly modified)

PHP backup mysql database (joomla database can be used directly, other databases can be slightly modified)_PHP tutorial

WBOY

Release： 2016-07-14 10:09:50

Original

859 people have browsed it

[php]
require_once('configuration.php');
$jconfig = new JConfig();
$connect = mysql_connect($jconfig->host ,$jconfig->user, $jconfig->password);
$result = mysql_list_tables($jconfig->db);
$tables = array();
while ($row = mysql_fetch_row($result)) {
    $tables[] = $row[0];
}

mysql_select_db($jconfig->db);
$sql = '';
foreach($tables as $table){
    $sql .= backupTable($table);
}

$r = file_put_contents('tmp/backup_'.date('Y-m-d-H-i-s').'.sql', $sql);

if($r){
    die('success');
}else{
    die('lalala');
}

mysql_close($connect);

function backupTable($table){
    $sqltxt = "DROP TABLE IF EXISTS $table;n";

    $result = mysql_query("SHOW CREATE TABLE $table");
    $row = mysql_fetch_assoc($result);
    $createsql = $row['Create Table'];
    $sqltxt .= $createsql.";nn";

    $result = mysql_query("SELECT * FROM $table");

    $rows = array();
    while($row = mysql_fetch_assoc($result)){
        $fields = array();
        foreach($row as $field){
            $fields[] = '''.mysql_escape_string($field).''';
        }

        $rows[] = '('.implode(',', $fields).')';
    }
    if(!emptyempty($rows)){
        $sqltxt .= "INSERT INTO `$table` VALUES".implode(",n", $rows).";n";
    }


    $sqltxt .= "n";

    return $sqltxt;
}

require_once('configuration.php');
$jconfig = new JConfig();
$connect = mysql_connect($jconfig->host ,$jconfig->user, $jconfig->password);
$result = mysql_list_tables($jconfig->db);
$tables = array();
while ($row = mysql_fetch_row($result)) {
$tables[] = $row[0];
}

mysql_select_db($jconfig->db);
$sql = '';
foreach($tables as $table){
$sql .= backupTable($table);
}

$r = file_put_contents('tmp/backup_'.date('Y-m-d-H-i-s').'.sql', $sql);

if($r){
die('success');
}else{
die('lalala');
}

mysql_close($connect);

function backupTable($table){
$sqltxt = "DROP TABLE IF EXISTS $table;n";

$result = mysql_query("SHOW CREATE TABLE $table");
$row = mysql_fetch_assoc($result);
$createsql = $row['Create Table'];
$sqltxt .= $createsql.";nn";

$result = mysql_query("SELECT * FROM $table");

$rows = array();
while($row = mysql_fetch_assoc($result)){
  $fields = array();
  foreach($row as $field){
   $fields[] = '''.mysql_escape_string($field).''';
  }

  $rows[] = '('.implode(',', $fields).')';
}
if(!empty($rows)){
  $sqltxt .= "INSERT INTO `$table` VALUES".implode(",n", $rows).";n";
}

$sqltxt .= "n";

return $sqltxt;
}