note 85876 deleted from function.mysql-query by philip
| From: | philip@php.net | Date: | Fri, 04 Sep 2015 19:22:13 +0000 |
| Subject: | note 85876 deleted from function.mysql-query by philip | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-203655@lists.php.net to get a copy of this message | ||
Note Submitter: lanbotdevman
----
I modified a bit script originally posted by
ix at nivelzero dot ro
14-Aug-2005 01:07
This allows using large .sql files without getting 'memory size exhausted' error.
<?php
function parse_mysql_dump($url) {
$handle = @fopen($url, "r");
$query = "";
while(!feof($handle)) {
$sql_line = fgets($handle);
if (trim($sql_line) != "" && strpos($sql_line, "--") === false) {
$query .= $sql_line;
if (preg_match("/;[\040]*\$/", $sql_line)) {
$result = mysql_query($query) or die(mysql_error());
$query = "";
}
}
}
}
?>