php 在线导入mysql大数据程序

";

//print_r($data);

$data_new=array();

$tmp=array();

foreach ($data as $line) {

$line=trim($line);

if(strlen($line)==0){

continue;

}

if(substr($line,2)=='--'){

continue;

}

if(substr($line,2)=='/*'){

continue;

}

$tmp[]=$line;

if(substr($line,-1)==';'){

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

$tmp=array();

$data_new[]=$query;

}

}
$mysqli=new mysqli('localhost','root','test');

if($mysqli->connect_errno){

exit('数据库连接失败！');

}

$mysqli->query("set names utf8");
$error=array();

foreach($data_new as $sql){

$mysqli->query($sql);

$r=$mysqli->error;

if($r) $error[]=$r;

}

print_r($r);
/*
mysql>ALTER TABLE tbl2 DISABLE KEYS;

Query OK,0 rows affected (0.00 sec)
mysql>INSERT INTO tbl2 SELECT * FROM tbl1;

Query OK,2000000 row affected (36.30 sec)

Records: 2000000 Duplicates: 0 Warnings: 0
mysql>ALTER TABLE tbl2 ENABLE KEYS;

Query OK,0 rows affected (44.55 sec)
*/