PHP imports large amounts of data to MySQL (sample)

Fast MySQL Big Data backup Before using, first modify the SQL file name, database hostname, database user name, password, database name to import by following the code comments. Both the database file and the text are FTP-guided through the Web site directory, and then Web Access to the file is edit:bbs.it-home.org $file _name= "Bn_site.sql";//SQL file name to import $dbhost = "localhost";//Database host name $dbuser = "root";//Database user name $dbpass = "";//Database Password $dbname = "Bn_site"; Database name Set_time_limit (0);//Set the timeout to 0, indicating that it has been executed. When PHP is invalid in safe mode, a time-out is imported and a multipart import is required $fp = @fopen ($file _name, "R") or Die ("Cannot open SQL file");//Open File Mysql_connect ($dbhost, $dbuser, $dbpass) or Die ("Cannot connect to database"); Connecting to a database mysql_select_db ($dbname) or Die ("Cannot open database");//Open database echo "Performing the import operation"; while ($SQL =getnextsql ()) { if (!mysql_query ($sql)) { echo "Execution error:". Mysql_error (). " "; The echo "SQL statement is: ". $SQL." "; }; } echo "Import complete"; Fclose ($fp) or Die ("can" T close file $file "); Close File Mysql_close (); Fetch SQL from File function Getnetsql () { Global $fp; $sql = ""; while ($line = @fgets ($fp, 40960)) { $line =trim ($line); The third sentence is not required in the high version of PHP and may need to be modified in some lower versions $line = Str_replace ("\\\\", "\ \", $line); $line = Str_replace ("\ '", "'", $line); $line = Str_replace ("\\r\\n", Chr. chr), $line); if (strlen ($line) >1) { if ($line [0]== "-" && $line [1]== "-") { Continue } } $sql. = $line. chr (10); if (strlen ($line) >0) { if ($line [strlen ($line) -1]== ";") { Break } } } return $sql; } ?> Copy Code

