Php online mysql big data import program, mysql data import. Php online mysql big data import program, mysql data import 1? Php2header (content-type: texthtml; charsetutf-8); 3error_reporting (E_ALL); 4set_time_limit (0); 5 $ file php online mysql big data import program, mysql data import
1
"; 9 // print_r ($ data); 10 $ data_new = array (); 11 $ tmp = array (); 12 foreach ($ data as $ line) {13 14 $ line = trim ($ line); 15 if (strlen ($ line) = 0) {16 continue; 17} 18 if (substr ($ line, 0, 2) = '--') {19 continue; 20} 21 if (substr ($ line,) = '/*') {22 continue; 23} 24 $ tmp [] = $ line; 25 if (substr ($ line,-1) = ';') {26 $ query = implode ('', $ tmp); 27 $ tmp = array (); 28 $ data_new [] = $ query; 29} 30 31} 32 33 34 35 $ mysqli = new mysqli ('lo Calhost ', 'root', 'root', 'test'); 36 if ($ mysqli-> connect_errno) {37 exit ('database connection failed! '); 38} 39 $ mysqli-> query ("set names utf8"); 40 41 $ error = array (); 42 foreach ($ data_new as $ SQL) {43 $ mysqli-> query ($ SQL); 44 $ r = $ mysqli-> error; 45 if ($ r) $ error [] = $ r; 46} 47 print_r ($ r); 48 49 50/* 51 52 53 mysql> alter table tbl2 disable keys; 54 Query OK, 0 rows affected (0.00 sec) 55 56 mysql> insert into tbl2 SELECT * FROM tbl1; 57 Query OK, 2000000 row affected (36.30 sec) 58 Records: 2000000 Duplicates: 0 Warnings: 059 60 mysql> alter table tbl2 enable keys; 61 Query OK, 0 rows affected (44.55 sec) 62 63 64 */
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.
Http://www.bkjia.com/PHPjc/1014830.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/1014830.htmlTechArticlephp online mysql big data import program, mysql data import 1? Php 2 header ("content-type: text/html; charset = utf-8"); 3 error_reporting (E_ALL); 4 set_time_limit (0); 5 $ file =...