database backup from mysql

[amitpura]

hi i want to backup of a only one table from mysql database. i use this code but this give me full database backup so plese give me right code any one.

<?php
ob_start();
set_time_limit(0);
$username="root";
$password="";
$database="amit";
mysql_connect('localhost',$username,$password);
mysql_select_db($database) or die('unable to select database');
include("configuration.php");

function tep_not_null($value) {
if (is_array($value)) {
if (sizeof($value) > 0) {
return true;
} else {
return false;
}
} else {
if ( (is_string($value) || is_int($value)) && ($value != '') && ($value != 'NULL') && (strlen(trim($value)) > 0)) {
return true;
} else {
return false;
}
}
}

$backup_file="database_backup/";

$mschema="";
define('LOCAL_EXE_GZIP', '/usr/bin/gzip');
define('LOCAL_EXE_GUNZIP', '/usr/bin/gunzip');
define('LOCAL_EXE_ZIP', '/usr/local/bin/zip');
define('LOCAL_EXE_UNZIP', '/usr/local/bin/unzip');
define('DIR_FS_BACKUP', '');

$sitename="amitsite";
  if (!is_dir($backup_file)) die("<br>Directory not found");

$backup_file.= 'db'.$sitename.date('d-M-Y') . '.sql';
$linkfile='db'.$sitename.date('d-M-Y') . '.sql';
// $backup_file='mysql.sql';

 //  $fp = fopen($backup_file, 'w');

 //  $schema = '# Mutants Technology, online web technology assistant' . "\n" .
        //      '# Database Backup For ' . "\n" .
         //     '# Copyright (c) ' . date('Y') . ' ' . "\n" .
         //     '#' . "\n" .
         ////     '# Database: gaf' . "\n" .
          //    '# Database Server: sql10.webair.com' . "\n" .
         //     '#' . "\n" .
         //     '# Backup Date: m/d/Y H:i:s' . "\n\n";


	// echo $schema;
         //      fputs($fp, $schema);


    $tables_query = mysql_query('show tables');

    while ($tables = mysql_fetch_array($tables_query)) {

      list(,$table) = each($tables);

      $schema = 'drop table if exists ' . $table . ';' . "\n" .
                'create table ' . $table . ' (' . "\n";

      $table_list = array();
      $fields_query = mysql_query("show fields from " . $table);
      while ($fields = mysql_fetch_array($fields_query)) {
        $table_list[] = $fields['Field'];

        $schema .= '  ' . $fields['Field'] . ' ' . $fields['Type'];

        if (strlen($fields['Default']) > 0) $schema .= ' default \'' . $fields['Default'] . '\'';

        if ($fields['Null'] != 'YES') $schema .= ' not null';

        if (isset($fields['Extra'])) $schema .= ' ' . $fields['Extra'];

        $schema .= ',' . "\n";
      }

      $schema = ereg_replace(",\n$", '', $schema);

// add the keys
$index = array();
$keys_query = mysql_query("show keys from " . $table);
while ($keys = mysql_fetch_array($keys_query)) {
$kname = $keys['Key_name'];

        if (!isset($index[$kname])) {
          $index[$kname] = array('unique' => !$keys['Non_unique'],
                                 'columns' => array());
        }

        $index[$kname]['columns'][] = $keys['Column_name'];
      }

      while (list($kname, $info) = each($index)) {
        $schema .= ',' . "\n";

        $columns = implode($info['columns'], ', ');

        if ($kname == 'PRIMARY') {
          $schema .= '  PRIMARY KEY (' . $columns . ')';
        } elseif ($info['unique']) {
          $schema .= '  UNIQUE ' . $kname . ' (' . $columns . ')';
        } else {
          $schema .= '  KEY ' . $kname . ' (' . $columns . ')';
        }
      }

      $schema .= "\n" . ');' . "\n\n";
     //  fputs($fp, $schema);
	 $mschema.=$schema;

//echo $schema;
// dump the data
$rows_query = mysql_query("select " . implode(',', $table_list) . " from " . $table);
while ($rows = mysql_fetch_array($rows_query)) {

       $schema = 'insert into ' . $table . ' (' . implode(', ', $table_list) . ') values (';

        reset($table_list);
        while (list(,$i) = each($table_list)) {
          if (!isset($rows[$i])) {
            $schema .= 'NULL, ';
          } elseif (tep_not_null($rows[$i])) {
            $row = addslashes($rows[$i]);
            $row = ereg_replace("\n#", "\n".'\#', $row);

            $schema .= '\'' . $row . '\', ';
          } else {
            $schema .= '\'\', ';
          }
        }

        $schema = ereg_replace(', $', '', $schema) . ');' . "\n";

    //   fputs($fp, $schema);

//echo $schema;
$mschema.=$schema;
// exit;

      }
    }

$myFile=$backup_file;
$fh = fopen($myFile, 'w') or die("can't open file");
$stringData =$mschema;
fwrite($fh, $stringData);
fclose($fh);
header('Content-type: application/x-octet-stream');
header('Content-disposition: attachment; filename=' .$linkfile);
echo $mschema;

?>

[cahva]

Please use the code tags in the future thanks.

Replace this:

$tables_query = mysql_query('show tables');

while ($tables = mysql_fetch_array($tables_query)) {

list(,$table) = each($tables);

With this:

$tlist = array('sometable');

foreach ($tlist as $table)) {

If you want to back up more tables, just add them to the $tlist array.