<?php
   $dbhost = 'XXXXXXX';
   $dbuser = 'XXXXXXX';
   $dbpass = 'XXXXXXX';

   $conn = mysqli_connect($dbhost, $dbuser, $dbpass);

   if(! $conn ) {
      die('Could not connect: ' . mysql_error());
   }

   $table_name = "chofer";
   $backup_file  = "chofer.sql";
   $sql = "LOAD DATA INFILE '$backup_file' INTO TABLE $table_name";

   mysqli_select_db($conn,'test_db');
   $retval = mysqli_query($conn, $sql);

   if(! $retval ) {
      die('No se puede acceder al registro : ' . mysql_error());
   }

  echo "<script>";
  echo "alert ('Restauración exitosa.');";
  echo "window.location.replace('index.php');";
  echo "</script>";

   mysqli_close($conn);
?>