Evo je Ilija, trebalo bi da moze i komentare fino da preskoci.
//Preuzeto sa php.net, autor: sb at stephenbrooks dot org
function load_db_dump($file,$sqlserver,$user,$pass,$dest_db ) {
$sql=mysql_connect($sqlserver,$user,$pass);
mysql_select_db($dest_db);
$a=file($file);
foreach ($a as $n => $l) if (substr($l,0,2)=='--') unset($a[$n]);
$a=explode(";\n",implode("\n",$a));
unset($a[count($a)-1]);
foreach ($a as $q) if ($q)
if (!mysql_query($q)) {echo "Fail on '$q'"; mysql_close($sql); return 0;}
mysql_close($sql);
return 1;
}
Pretpostavka je da se redovi zavrsavaju sa ;\n
Nisam probao, ali mislim da ce da radi...
|