backupDoDataOnly.php

<?php
#require backupDoGo.php
# Script to automatically backup MySQL Database
# Authors: FR, radeff@akademia.ch
# Adapted from: http://www.journaldunet.com/developpeur/tutoriel/php/050304-php-dump-mysql.shtml
# History
# Thu, 14 Jun 2007: FR, created
# Copyright (C) GNU GENERAL PUBLIC LICENSE

	include_once("../common/dbConnection.pdf.php");

 function mysql_structure() {
  /*$host = "localhost";
  $user = "root";
  $pass = "";
  $base = "semforminfo";*/
	
$serveur= $_SERVER["HTTP_HOST"];
if($serveur=="localhost") { //serveur de développement
      $dbUsername = "";
      $dbPassword = "";
      $dbHostname = "localhost";
      $dbName     = "";      

} elseif ($serveur==""){ //serveur de prod
      $dbUsername = "";
      $dbPassword = "";
      $dbHostname = "localhost";
      $dbName     = "";      

} elseif ($serveur==""){ //serveur de backups
      $dbUsername = "";
      $dbPassword = "";
      $dbHostname = "localhost";
      $dbName     = "";      

}


  $host = $dbHostname;
  $user = $dbUsername;
  $pass = $dbPassword;
  $base = $dbName;
  #echo "mysql_connect($host, $user, $pass,$base)";
  mysql_connect($host, $user, $pass);
  mysql_select_db($base);

  $tables = mysql_list_tables($base);
  while ($donnees = mysql_fetch_array($tables))
    {
    $table = $donnees[0];
    $res = mysql_query("SHOW CREATE TABLE $table");
    if ($res)
      {
      $insertions = "";
      $tableau = mysql_fetch_array($res);

      #$dumpsql[] = str_replace("\n", "", $tableau[1]);
      $req_table = mysql_query("SELECT * FROM $table");
      $nbr_champs = mysql_num_fields($req_table);
      while ($ligne = mysql_fetch_array($req_table))
        {
        $insertions .= "INSERT INTO $table VALUES(";
        for ($i=0; $i<=$nbr_champs-1; $i++)
          {
          $insertions .= "'" . mysql_real_escape_string($ligne[$i]) . "', ";
          }
        $insertions = substr($insertions, 0, -2);
        $insertions .= ");\n";
        }
      if ($insertions != "")
        {
        $dumpsql[] = $insertions;
        }
      }
    }
 /* return "USE " .$base .";

" .implode("\r", $dumpsql);*/
return implode("\r", $dumpsql);
  }

#echo "Taille du fichier: ";
$content=mysql_structure();
$content="
" .$content;
#echo "<pre>" .$content ."</pre>";
echo "" .$content ."";


?>