[Sommaire] [Imprimer]

   1  <?PHP
   2  /* Copyright (C) 2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
   3   *
   4   * This program is free software; you can redistribute it and/or modify
   5   * it under the terms of the GNU General Public License as published by
   6   * the Free Software Foundation; either version 2 of the License, or
   7   * (at your option) any later version.
   8   *
   9   * This program is distributed in the hope that it will be useful,
  10   * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12   * GNU General Public License for more details.
  13   *
  14   * You should have received a copy of the GNU General Public License
  15   * along with this program; if not, write to the Free Software
  16   * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
  17   *
  18   * $Id: dump.php,v 1.2 2005/10/18 14:03:06 eldy Exp $
  19   * $Source: /cvsroot/dolibarr/dolibarr/scripts/dump.php,v $
  20   */
  21  
  22  require_once ("../htdocs/master.inc.php");
  23  
  24  $fname = '/tmp/dump.sh';
  25  
  26  $fp = fopen($fname,"w");
  27  
  28  $excl = "llx_telephonie_communications_details";
  29  
  30  $sql = "SHOW TABLES";
  31  
  32  $resql = $db->query($sql);
  33  
  34  if ($resql)
  35  {
  36    $i = 0;
  37    $num = $db->num_rows($resql);
  38  
  39    while ($i < $num)
  40      {
  41        $row = $db->fetch_row($resql);
  42  
  43  
  44        if ($row[0] <> $excl)
  45      {
  46  
  47        $line = "mysqldump ".$dolibarr_main_db_name." ".$row[0] . " >> /tmp/dump.sql";
  48  
  49        fputs($fp, $line."\n");      
  50      }
  51        $i++;
  52      }
  53  }
  54  fclose($fp);
  55  $db->close();
  56  ?>