search

Home >Backend Development >PHP Tutorial >PHP imports large amounts of data into mysql (example)

PHP imports large amounts of data into mysql (example)

WBOY
WBOYOriginal
2016-07-25 08:54:581804browse

  3. //Fast Mysql big data backup

  4. //Before use, please first modify the SQL file name, database host name, database user name, and password to be imported according to the code comments ,Database name.
  5. //At the same time, ftp the database file and text into the website directory, and then access this file in WEB mode
  6. //edit: bbs.it-home.org
  7. $file_name="bn_site.sql";//To be imported SQL file name
  8. $dbhost="localhost";//Database host name
  9. $dbuser="root";//Database user name
  10. $dbpass="";//Database password
  11. $dbname="bn_site"; // Database name
  12. set_time_limit(0);//Set the timeout to 0, which means it will always be executed. When php is invalid in safe mode, the import will time out. At this time, it needs to be imported in sections
  13. $fp=@fopen($file_name,"r") or die ("Cannot open SQL file");//Open the file
  14. mysql_connect($dbhost,$dbuser,$dbpass) or die("Cannot connect to database"); //Connect to database
  15. mysql_select_db($dbname) or die("Cannot open database"); //Open database
  16. echo "is Execute import operation";
  17. while($SQL=GETNEXTSQL()){
  18. if(!mysql_query($sql)){
  19. echo "Execution error: ".mysql_error()."
    ";
  20. echo "The SQL statement is:
    ".$SQL."
    ";
  21. };

  22. }

  23. echo "Import completed ";

  24. fclose($fp) or die ("can"t close file $file"); //Close the file

  25. mysql_close();
  26. //From file Get SQL item by item in
  27. function GETNETSQL(){
  28. global $fp;
  29. $sql="";
  30. while( $line=@fgets($fp,40960)){
  31. $line=trim($line);
  32. / /The following three sentences are not needed in higher versions of PHP, but may need to be modified in some lower versions.
  33. $line = str_replace("\\","\",$line);
  34. $line = str_replace("'"," '",$line);
  35. $line = str_replace("\r\n",chr(13).chr(10),$line);
  36. if (strlen($line)>1){
  37. if ( $line[0]=="-"&& $line[1]=="-"){
  38. continue;
  39. }
  40. }

  41. $sql.=$line.chr(13 ).chr(10);

  42. if (strlen($line)>0){
  43. if ($line[strlen($line)-1]==";"){
  44. break;
  45. }
  46. }
  47. }
  48. return $sql;
  49. }
  50. ?>

Copy code


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
Previous article：A small example of replacing array key names in PHPNext article：A small example of replacing array key names in PHP

Related articles

See more