Php online import mysql Big Data Program

I think many people often use phpmyadmin to import and export data. However, in many cases, it is okay to export data using virtual hosts, but there is a big problem in importing data, I don't want to talk about webmasters here.

I think many people often use phpmyadmin to import and export data. However, in many cases, it is okay to export data using virtual hosts, but there is a big problem in importing data, I don't want to talk about webmasters here.

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"

"; // 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, 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 )*/
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 ("Your 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.