$con=mysql_connect("DBHost","DBUsrName","DbPwd");
mysql_select_db("DBName");
$sqlfile = 'File.sql';
$contents = file_get_contents($sqlfile);
$comment_patterns = array('/\/\*.*(\n)*.*(\*\/)?/',
'/\s*--.*\n/',
'/\s*#.*\n/',
);
$contents = preg_replace($comment_patterns, "\n", $contents);
$statements = explode(";\n", $contents);
$statements = preg_replace("/\s/", ' ', $statements);
foreach ($statements as $query) {
if (trim($query) != '') {
$result = mysql_query($query);
if (!$result) {
echo 'Error ' . $query . ': ' . mysql_error();
}
}
}
