Datenbank sichern wie in PHPmyAdmin

<?

// (c) 2005 by user-182

// http://FrankyOnline.de/

// Dieser Vermerk darf nicht entfernt werden



function parsefield($field, $typ){

  if($typ == 'integer' return $field;

  else{

    $field = addslashes($field);

    $field = str_replace("\t", "\\t", $field);

    $field = str_replace("\r", "\\r", $field);

    $field = str_replace("\n", "\\n", $field);

    return '\''.$field.'\'';

  }

}



function mysql_export_table($table, $connection=''{

  // Struktur

  $dump = "CREATE TABLE `".$table."` (\n";

  

  $types = array();

  $result = mysql_query('DESCRIBE '.$table, $connection);

  $count = mysql_num_rows($result);

  

  $i = 0;

  while($row = mysql_fetch_array($result)){

    $name = $row['Field'];

    $typ = ' '.$row['Type'];

    

    $fieldtypes[$name] = (!stristr($row['Type'], "ENUM" && ((stristr($row['Type'], "INT" || stristr($row['Type'], "FLOAT" || stristr($row['Type'], "DOUBLE" || stristr($row['Type'], "REAL" || stristr($row['Type'], "DECIMAL" || stristr($row['Type'], "NUMERIC" || stristr($row['Type'], "TIMESTAMP" || stristr($row['Type'], "YEAR")) ? ("integer" : ("string");

    

    if($row['Null'] == '' $null = ' NOT NULL';

    else $null = ' NULL';

      

    if($row['Default'] == '' $default = '';

    else $default = " DEFAULT '".$row['Default']."'";

    

    if($row['Extra'] == '' $extra = '';

    else $extra = ' '.$row['Extra'];

    

    $dump .= "  ".$name.$typ.$null.$default.$extra;

    

    $i++;

    if($i < $count) $dump .= ", \n";

  }

      

  $index = array();

  $result = mysql_query('SHOW KEYS FROM '.$table, $connection);

  while($row = mysql_fetch_array($result)){

    $keyname = $row['Key_name'];

    $comment = (isset($row['Comment'])) ? $row['Comment'] : '';

    $sub_part = (isset($row['Sub_part'])) ? $row['Sub_part'] : '';

        

    if($keyname != 'PRIMARY' && $row['Non_unique'] == 0) $keyname = 'UNIQUE|'.$keyname;

      

    if($comment == 'FULLTEXT' $keyname = 'FULLTEXT|'.$keyname;



    if(!isset($index[$keyname])) $index[$keyname] = array();

      

    if($sub_part > 1) $index[$keyname][] = $row['Column_name']."(".$sub_part."";

    else $index[$keyname][] = $row['Column_name'];

  }

  mysql_free_result($result);

  

  foreach($index as $keyname => $columns){

    $dump .= ", \n";

    if($keyname == "PRIMARY" $dump .= "  PRIMARY KEY (";

    elseif(substr($keyname, 0, 6) == "UNIQUE" $dump .= "  UNIQUE ".substr($keyname, 7)." (";

    elseif(substr($keyname, 0, 8) == "FULLTEXT" $dump .= "  FULLTEXT ".substr($keyname, 9)." (";

    else $dump .= "  KEY ".$keyname." (";

    

    $dump .= implode($columns, ", ".'';

  }

  

  $dump .= "\n);\n\n";

  

  

  

  // Content

  $insert_tag = 0;

  $rowcount = 0;

  $result = mysql_query('SELECT * FROM '.$table, $connection);

  while($row = mysql_fetch_array($result, MYSQL_ASSOC)){

    $values = '';

    foreach($row as $key => $field)

      if($values != '' $values .= ','.parsefield($field, $fieldtypes[$key]);

      else $values = parsefield($field, $fieldtypes[$key]);

    

    if($insert_tag == 0){

      $dump .= 'INSERT INTO '.$table.' VALUES ('.$values.'';

      $insert_tag = 1;    

    }else $dump .= ',('.$values.'';



    if($insert_tag == 1 && $rowcount == 500){

      $dump .= ";\n";

      $insert_tag = 0;

      $rowcount = 0;

    }

    

    $rowcount++;

  }

  mysql_free_result($result);

  

  if($insert_tag == 1) $dump .= ";\n";

  

  return $dump;

}

?>

<?

$mysqlconnect = mysql_connect('localhost', 'root', '';

$result = mysql_list_tables('datenbank', $mysqlconnect);

$num_tables = mysql_num_rows($result);



for($i=0;$i<$num_tables;$i++){

  $table = mysql_tablename($result, $i);

  echo mysql_export_table($table, $mysqlconnect);

}



mysql_free_result($result);

mysql_close($mysqlconnect);

?>

CREATE TABLE `counter` (

  `datum` date NOT NULL default '0000-00-00',

  `visitors` int(5) NOT NULL default '0',

  PRIMARY KEY  (`datum`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;



INSERT INTO `counter` VALUES ('2005-09-03', 25);

INSERT INTO `counter` VALUES ('2005-09-04', 48);

INSERT INTO `counter` VALUES ('2005-09-05', 31);

# ...