PHP online import mysql big data program_PHP tutorial-PHP Tutorial-php.cn

PHP online import mysql big data program_PHP tutorial

WBOY

Release： 2016-07-13 09:51:06

Original

806 people have browsed it

php online import mysql big data program

header("content-type:text/html;charset=utf-8");

error_reporting(E_ALL);

set_time_limit(0);

$file='./test.sql';

$data=file($file);

echo "

";
            //print_r($data);
            $data_new=array();
            $tmp=array();
            foreach ($data as $line) {
             
            $line=trim($line);
            if(strlen($line)==0){
            continue;
            }
            if(substr($line,0,2)=='--'){
            continue;
            }
            if(substr($line,0,2)=='/*'){
            continue;
            }
            $tmp[]=$line;
            if(substr($line,-1)==';'){
            $query=implode('',$tmp);
            $tmp=array();
            $data_new[]=$query;
            }
            }
             
            $mysqli=new mysqli('localhost','root','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)
             
            */

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58

<🎜>header("content-type:text/html;charset=utf-8");<🎜> <🎜>error_reporting(E_ALL);<🎜> <🎜>set_time_limit(0);<🎜> <🎜>$file='./test.sql';<🎜> <🎜>$data=file($file);<🎜> <🎜> <🎜> <🎜>echo "

";
            //print_r($data);
            $data_new=array();
            $tmp=array();
            foreach ($data as $line) {
             
            $line=trim($line);
            if(strlen($line)==0){
            continue;
            }
            if(substr($line,0,2)=='--'){
            continue;
            }
            if(substr($line,0,2)=='/*'){
            continue;
            }
            $tmp[]=$line;
            if(substr($line,-1)==';'){
            $query=implode('',$tmp);
            $tmp=array();
            $data_new[]=$query;
            }
            }
             
            $mysqli=new mysqli('localhost','root','root','test');
            if($mysqli->connect_errno){
            exit('Database connection failed!');
            }
            $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)
             
            */

Applicable situation: The sql file exported by phpmyadmin is too large and cannot be imported into online phpmyadmin

Upload the program and sql file to the space and delete it after use.

Share a method from other netizens, friends can also refer to it

$rate_info = file("$table.txt");

print $n_s = chop($rate_info[0]);

for($start=1;$start

{

$value="";

for ($i=$start;$i<($start $n_s-1);$i )

{

$tmp = str_replace("&&jimmy&&"," ",chop($rate_info[$i]));

$value .= "'".addslashes($tmp)."',";

}

$tmp = str_replace("&&jimmy&&"," ",chop($rate_info[$start $n_s-1]));

$value .= "'".$tmp."'";

$query = "insert into $table values (".$value.")";

print mysql_error();

mysql_query($query);

print $start." ";

}

print "ostart";

1 2

12 13

14 15 16 17 18 19

$rate_info = file("$table.txt"); print $n_s = chop($rate_info[0]); for($start=1;$start { $value=""; for ($i=$start;$i<($start $n_s-1);$i )<🎜> <🎜>{<🎜> <🎜>$tmp = str_replace("&&jimmy&&"," ",chop($rate_info[$i]));<🎜> <🎜>$value .= "'".addslashes($tmp)."',";<🎜> <🎜>}<🎜> <🎜>$tmp = str_replace("&&jimmy&&"," ",chop($rate_info[$start $n_s-1]));<🎜> <🎜>$value .= "'".$tmp."'";<🎜> <🎜>$query = "insert into $table values (".$value.")";<🎜> <🎜>print mysql_error();<🎜> <🎜>mysql_query($query);<🎜> <🎜>print $start." ";<🎜> <🎜>}<🎜> <🎜>print "ostart";<🎜> <🎜>?>

The above is the entire content of this article, I hope you all like it. http://www.bkjia.com/PHPjc/1015336.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1015336.htmlTechArticlephp online import mysql big data program php online import mysql big data program 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38...