Záloha databáze

error_reporting(error_reporting() & ~E_NOTICE);

mysqldump -A -u uzivatelskejmeno -p uzivatelskeheslo > zaloha.sql

exec('mysqldump -A -u foo -p mypass > /tmp/backup.' . date('Y-m-d_His') . '.sql');

/**
 * Zalohuje databazi do souboru.
 *
 * @param string $host
 * @param string $user
 * @param string $pass
 * @copyright http://davidwalsh.name/backup-mysql-database-php
 */
function backupDatabase($host, $user, $pass)
{
    $db = mysql_connect($host,$user,$pass);
    $db_list = mysql_list_dbs($db);
    while ($row = mysql_fetch_assoc($db_list))
    {
	mysql_select_db($row['Database'], $db);

	$tables = Array();
	$result = mysql_query('SHOW TABLES') or die (mysql_error());
	while($row = mysql_fetch_row($result))
	{
	    $tables[] = $row[0];
	}

	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] = ereg_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";
	}
    }

    $fp = fOpen('db-backup-' . Date('d-m-Y') . '.sql', 'w+');
    fWrite($fp, $return);
    fClose($fp);
}


backupDatabase('server', 'uzivatelskeJmeno', 'heslo');

exec(' mysqldump -A --host=12.34.56.78 --user=foo --password=mypass > /tmp/backup.' . date('Y-m-d_His') . '.sql');

$t = microtime(true);
for ($i = 0; $i < 100000; $i++) {
	@$x;
}
echo $a = microtime(true) - $t;

echo '<br>';

error_reporting(error_reporting() & ~E_NOTICE);
$t = microtime(true);
for ($i = 0; $i < 100000; $i++) {
	$x;
}
echo $b = microtime(true) - $t;

echo '<br>';

echo $a / $b;

<?php
function zalohuj($db,$soubor=""){
  $text="";

  function keys($prefix,$array){
    $array=Array();
    $radky="";
    $pocet = count($array);
    $posledni = $pocet-1;
    if($pocet == 0)
      return;
    for($i = 0; $i<$pocet; $i++){
      if($i != $posledni)
        $carka = ",";
      else
        $carka = "";
      $radky .= "`$array[$i]`$carka";
    }
    return ",\n$prefix($radky)";
  }

  $sql = mysql_query("SHOW TABLE STATUS FROM $db");


  while($data = mysql_fetch_array($sql)){
    $PRI=$UNI=$MUL="";

    $text .= "--\n-- Struktura tabulky $data[0]\n--\n\n";
    $text .= "CREATE TABLE `$data[0]`(\n";
    $sqll = mysql_query("show columns from $data[0]") or die ("Nastala chyba: " . mysql_error());
    $e = true;
    while($dataa = mysql_fetch_array($sqll)){
      if($e){
        $e = false;
      }
      else
      $text .= ",\n";
      $null = ($dataa[2] == "NO")? "NOT NULL":"NULL";
      $default = !empty($dataa[4])? " DEFAULT '$dataa[4]'":false;
      

      if($default == " DEFAULT 'CURRENT_TIMESTAMP'") $default = " DEFAULT CURRENT_TIMESTAMP";
      if($dataa[3] == "PRI") $PRI[] = $dataa[0];
      if($dataa[3] == "UNI") $UNI[] = $dataa[0];
      if($dataa[3] == "MUL") $MUL[] = $dataa[0];
      $extra = !empty($dataa[5])? " ".$dataa[5]:false;
      $text .= "`$dataa[0]` $dataa[1] $null$default$extra";
    }
    $primary = keys("PRIMARY KEY",$PRI);
    $unique = keys("UNIQUE KEY",$UNI);
    $mul = keys("INDEX",$MUL);
    $text .= "$primary$unique$mul\n) ENGINE=$data[Engine] COLLATE=$data[Collation];\n\n";
    unset($PRI,$UNI,$MUL);
    #data
    $text .= "--\n-- Data tabulky $data[0]\n--\n\n";
    $query = mysql_query("SELECT * FROM $data[0]");
    while($fetch = mysql_fetch_array($query)){
      $values="";
      $pocet_sloupcu = count($fetch)/2;
      $i = 0;
      while($i < $pocet_sloupcu){
        if($i < $pocet_sloupcu-1)
          $carka = ",";
        else
          $carka = "";
        $values .= "'".mysql_escape_string($fetch[$i])."'$carka";
        $i++;
      }
      $text .= "\nINSERT INTO `$data[0]` VALUES($values);";
      unset($values);
    }
  }

  if(!empty($soubor)){
    $fp = @fopen($soubor,"w+");
    $fw = @fwrite($fp,$text);
    @fclose($fp);
  }
  
  return $text;
}

$hostiteldb="localhost";
$jmenodb="mysql_uzivatel";
$heslodb="mysql_heslo";
$db="databaze";

mysql_connect($hostiteldb, $jmenodb, $heslodb);
mysql_query("SET NAMES 'utf8'");
mysql_select_db($db);

$text = zalohuj($db,"zaloha_mysql".date("-d-m-Y").".sql");
echo "<textarea>$text</textarea>";?>