php 在线导入mysql大数据程序,php导入mysql数据
php 在线导入 mysql 大数据程序
<?php header("content-type:text/html;charset=utf-8"); error_reporting(E_ALL); set_time_limit(0); $file='./test.sql'; $data=file($file); echo "<pre class="brush:php;toolbar:false">"; //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) */
适用情况:phpmyadmin导出的sql文件过大,无法导入到线上phpmyadmin中
把该程序和sql文件上传到空间中,用完后删除即可。
分享一个其他网友的方法吧,小伙伴们也可以参考下
$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"; ?>
以上所述就是本文的全部内容了,希望大家能够喜欢。
Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article
Assassin's Creed Shadows: Seashell Riddle Solution
3 weeks agoByDDD
What's New in Windows 11 KB5054979 & How to Fix Update Issues
2 weeks agoByDDD
Where to find the Crane Control Keycard in Atomfall
3 weeks agoByDDD
Assassin's Creed Shadows - How To Find The Blacksmith And Unlock Weapon And Armour Customisation
1 months agoByDDD
Roblox: Dead Rails - How To Complete Every Challenge
3 weeks agoByDDD

Hot Tools

Dreamweaver CS6
Visual web development tools

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

Zend Studio 13.0.1
Powerful PHP integrated development environment

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool