Php imports mysql Big Data Program online, and php imports mysql Data
Php online import mysql Big Data Program
<? Phpheader ("content-type: text/html; charset = UTF-8"); error_reporting (E_ALL); set_time_limit (0); $ file = '. /test. SQL '; $ data = file ($ file); echo "<pre>"; // print_r ($ data); $ data_new = array (); $ tmp = array (); foreach ($ data as $ line) {$ line = trim ($ line); if (strlen ($ line) = 0) {continue ;} if (substr ($ line,) = '--') {continue;} if (substr ($ line,) = '/*') {continue ;} $ tmp [] = $ line; if (substr ($ line,-1) = ';') {$ query = im Plode ('', $ 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 )*/
Applicability: the SQL file exported by phpmyadmin is too large to be imported to online phpmyadmin.
Upload the program and SQL file to the space and delete it after use.
Share the methods of other netizens. For more information, see
$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 all the content of this article. I hope you will like it.