[SOLVED] Executing .sql file

[PHP_PhREEEk]

Good solution, Thorpe, but alas, it's rare for someone to have exec privileges through PHP. That's one of the first things locked down on a shared server.

 

Best,

PhREEEk

[AV]

#thorpe

As PHP_PhREEEK said, I either have not privilleges to use exec()

 

#MadTechie

$url = file_get_contents('db_data.sql');

 function parse_mysql_dump($url, $ignoreerrors = false) {
  $file_content = file($url);
  $query = "";
  foreach($file_content as $sql_line) {
    $tsl = trim($sql_line);
    if (($tsl != "") && (substr($tsl, 0, 2) != "--") && (substr($tsl, 0, 1) != "#")) {
      $query .= $sql_line;
      if(preg_match("/;\s*$/", $sql_line)) {
        $result = mysql_query($query);
        if (!$result && !$ignoreerrors) die(mysql_error());
        $query = "";
      }
    }
  }
 }

Doesn't work either, no errors.

[AV]

Done, I used this one: http://www.ozerov.de/bigdump.php