ใช้ BigDump แล้วขึ้นแบบนี้ทำไงดีครับ

[guy852]

ข้อมูลยาวประมาณ หนึ่งแสนสามหมื่นบรรทัดครับ

โค้ด เลือก ขยาย

INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389291520","1389291775","US","UNITED STATES","NA","NORTH AMERICA")
INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389291776","1389292031","GB","UNITED KINGDOM","EU","EUROPE")
INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389292032","1389292799","GH","GHANA","AF","AFRICA")
INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389292800","1389293055","MG","MADAGASCAR","AF","AFRICA")
INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389293056","1389293311","US","UNITED STATES","NA","NORTH AMERICA")
INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389293312","1389293567","KE","KENYA","AF","AFRICA")
INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389293568","1389294335","GB","UNITED KINGDOM","EU","EUROPE")
INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389294336","1389294591","US","UNITED STATES","NA","NORTH AMERICA")
INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389294592","1389294847","GB","UNITED KINGDOM","EU","EUROPE")
INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389294848","1389296639","US","UNITED STATES","NA","NORTH AMERICA")
INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389296640","1389297151","TZ","TANZANIA, UNITED REPUBLIC OF","AF","AFRICA")
INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389297152","1389297663","GB","UNITED KINGDOM","EU","EUROPE")
INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389297664","1389330431","UA","UKRAINE","EU","EUROPE")
INSERT INTO `xxxx`.`xxxx` (`IP_FROM` ,`IP_TO` ,`COUNTRY_CODE` ,`COUNTRY_NAME` ,`CONTINENT_CODE` ,`CONTINENT_NAME`) VALUES ("1389330432","1389363199","DE","GERMANY","EU","EUROPE")

ผมยัดมันลงไปใน ฺBigDump แล้วมันขึ้นแบบนี้ครับ

Stopped at the line 301.

At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts. Please read the BigDump FAQs for more infos.

Stopped on error

[Tee++;]

ตอนก่อนทำมันมี line ให้ตั้ง ทำไมไม่ตั้งไปเยอะๆ ล่ะ

****มันอยู่ใน Config File

[ชงเข้ม]

ลองเข้าไป search ดู

http://www.google.co.th/search?q=At+this+place+the+current+query+includes+more+than+300+dump+lines.+That+can+happen+if+your+dump+file+was+created+by+some+tool+which+doesn%27t+place+a+semicolon+followed+by+a+linebreak+at+the+end+of+each+query%2C+or+if+your+dump+contains+extended+inserts.+Please+read+the+BigDump+FAQs+for+more+infos.&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:th:official&client=firefox-a

เจอของ powerpc ครับ
http://www.binarywebhost.com/forum/index.php?topic=28.0

โดนอาการเดียวกันครับ

At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts. Please read the BigDump FAQs for more infos.

ต้องแก้ config บรรทัดไหนครับ
db ผม 200 กว่าเมก

[ชงเข้ม]

โค้ด เลือก ขยาย

if ($ajax)
  ob_start();

define ('VERSION','0.29b');
define ('DATA_CHUNK_LENGTH',16384);  // How many chars are read per time
define ('MAX_QUERY_LINES',9999300);      // How many lines may be considered to be one query (except text lines)
define ('TESTMODE',false);           // Set to true to process the file without actually accessing the database

header("Expires: Mon, 1 Dec 2003 01:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");

ผมลองตั้งค่าตรงนี้ดู define ('MAX_QUERY_LINES',9999300);
ไปลองก่อน เดี๋ยวมาบอก