simple_backupdb_wp.php

<?php
include "wp-config.php";


backup_tables(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

/* backup the db OR just a table */
function backup_tables($host,$user,$pass,$name,$tables = '*') {

  $filename = "backup-" . date("d-m-Y") . ".sql";
  header('Content-Type: text');
  header( 'Content-Disposition: attachment; filename="' . $filename . '"' );
  header("Pragma: no-cache");
  header("Expires: 0");

  $link = mysql_connect($host,$user,$pass);
  mysql_select_db($name,$link);
  //get all of the tables
  if($tables == '*') {
    $tables = array();
    $result = mysql_query('SHOW TABLES');
    while($row = mysql_fetch_row($result)) {
      $tables[] = $row[0];
    }
  } else {
    $tables = is_array($tables) ? $tables : explode(',',$tables);
  }

  //cycle through
  foreach($tables as $table) {
    $result = mysql_query('SELECT * FROM '.$table);
    $num_fields = mysql_num_fields($result);

    echo  'DROP TABLE '.$table.';';
    $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
    echo  "\n\n".$row2[1].";\n\n";

    for ($i = 0; $i < $num_fields; $i++) {
      while($row = mysql_fetch_row($result)) {
        echo '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])) { echo '"'.$row[$j].'"' ; } else { echo '""'; }
          if ($j < ($num_fields-1)) { echo ','; }
        }
        echo ");\n";
        ob_flush(); flush();

      }
      echo "\n\n\n";
      ob_flush(); flush();
    }
  }
}

exit(0);
?>