backup && restore ช่วยดูโค๊ด ให้หน่อยครับ อันนี้โค๊ด backup ครับ อันนี้ทำได้ไม่มีปัญหาอะไร

<?php
  $ccyymmdd = date("Ymd");
  $file = fopen("c:\car_backup".$ccyymmdd.".sql","w");
  $line_count = create_backup_sql($file); 
  fclose($file);
  echo "lines written: ".$line_count;

  function create_backup_sql($file) {
    $line_count = 0;
    $db_connection = db_connect();
    mysql_select_db (db_name()) or exit();
    $tables = mysql_list_tables(db_name());
    $sql_string = NULL;
    while ($table = mysql_fetch_array($tables)) {   
      $table_name = $table[0];
      $sql_string = "DELETE FROM $table_name;";
      $table_query = mysql_query("SELECT * FROM `$table_name`");
      $num_fields = mysql_num_fields($table_query);
      while ($fetch_row = mysql_fetch_array($table_query)) {
        $sql_string .= "INSERT INTO $table_name VALUES(";
        $first = TRUE;
        for ($field_count=1;$field_count<=$num_fields;$field_count++){
          if (TRUE == $first) {
            $sql_string .= "'".mysql_real_escape_string($fetch_row[($field_count - 1)])."'";
            $first = FALSE;            
          } else {
            $sql_string .= ", '".mysql_real_escape_string($fetch_row[($field_count - 1)])."'";
          }
        }
        $sql_string .= ");";
        if ($sql_string != ""){
          $line_count = write_backup_sql($file,$sql_string,$line_count);        
        }
        $sql_string = NULL;
      }    
    }
    return $line_count;
  }

  function write_backup_sql($file, $string_in, $line_count) { 
    fwrite($file, $string_in);
    return ++$line_count;
  }
  
  function db_name() {
      return ("481651113-481651314_db");
  }
  
  function db_connect() {
    $db_connection = mysql_connect("localhost", "root", "");
    return $db_connection;
  }  
?>

<?php
  $file = fopen("c:\car_backup20090427.sql","w");
  $line_count = load_backup_sql($file);
  fclose($file);
  echo "lines read: ".$line_count;

  function load_backup_sql($file) {
    $line_count = 0;
    $db_connection = db_connect();
    mysql_select_db (db_name()) or exit();
    $line_count = 0;
    while (!feof($file)) {
      $query = NULL;
      while (!feof($file)) {
        $query .= fgets($file);
      }
      if (NULL != $query) {
        $line_count++;
        mysql_query($query) or die("sql not successful: ".mysql_error()." query: ".$query);
      }
    }  
    return $line_count;
  }
  
  function db_name() {
      return ("481651113-481651314_db");
  }
  
  function db_connect() {
    $db_connection = mysql_connect("localhost", "root", "");
    return $db_connection;
  }  
?>