php查询mysql文件_最佳做法：在PHP中导入mySQL文件拆分查询

这是一个内存友好的功能，应该能够在单个查询中分割大文件，而无需一次打开整个文件：

function SplitSQL($file, $delimiter = ';')

{

set_time_limit(0);

if (is_file($file) === true)

{

$file = fopen($file, 'r');

if (is_resource($file) === true)

{

$query = array();

while (feof($file) === false)

{

$query[] = fgets($file);

if (preg_match('~' . preg_quote($delimiter, '~') . '\s*$~iS', end($query)) === 1)

{

$query = trim(implode('', $query));

if (mysql_query($query) === false)

{

echo '

ERROR: ' . $query . '

' . "\n";

}

else

{

echo '

SUCCESS: ' . $query . '

' . "\n";

}

while (ob_get_level() > 0)

{

ob_end_flush();

}

flush();

}

if (is_string($query) === true)

{

$query = array();

}

}

return fclose($file);

}

}

return false;

}

我在一个大的phpMyAdmin SQL转储测试它，它的工作很好。

一些测试数据：

CREATE TABLE IF NOT EXISTS "test" (

"id" INTEGER PRIMARY KEY AUTOINCREMENT,

"name" TEXT,

"description" TEXT

);

BEGIN;

INSERT INTO "test" ("name", "description")

VALUES (";;;", "something for you mind; body; soul");

COMMIT;

UPDATE "test"

SET "name" = "; "

WHERE "id" = 1;

并分别输出：

SUCCESS: CREATE TABLE IF NOT EXISTS "test" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" TEXT, "description" TEXT );

SUCCESS: BEGIN;

SUCCESS: INSERT INTO "test" ("name", "description") VALUES (";;;", "something for you mind; body; soul");

SUCCESS: COMMIT;

SUCCESS: UPDATE "test" SET "name" = "; " WHERE "id" = 1;