blocks|key|203493|text|我已经测试了你的代码，当你已经导入了数据库或者有一些同名的表时，这个错误就会显示出来，还有数组错误会显示出来，这是因为你在exec括号中添加了这个错误，下面是修复后的版本：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|203494|<?php
//ENTER+THE+RELEVANT+INFO+BELOW
$mysqlDatabaseName+='test';
$mysqlUserName+='root';
$mysqlPassword+='';
$mysqlHostName+='localhost';
$mysqlImportFilename+='dbbackupmember.sql';
//DONT+EDIT+BELOW+THIS+LINE
//Export+the+database+and+output+the+status+to+the+page
$command='mysql+-h'+.$mysqlHostName+.'+-u'+.$mysqlUserName+.'+-p'+.$mysqlPassword+.'+'+.$mysqlDatabaseName+.'+<+'+.$mysqlImportFilename;
$output=array();
exec($command,$output,$worked);
switch($worked){
++++case+0:
++++++++echo+'Import+file+<b>'+.$mysqlImportFilename+.'</b>+successfully+imported+to+database+<b>'+.$mysqlDatabaseName+.'</b>';
++++++++break;
++++case+1:
++++++++echo+'There+was+an+error+during+import.';
++++++++break;
}
?>+|code-block|syntax|javascript|203495|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

<p>I have Test your code, this error shows when you already have the DB imported or with some tables with the same name, also the Array error that shows is because you add in in the exec parenthesis, here is the fixed version: </p>

<pre><code>&lt;?php
//ENTER THE RELEVANT INFO BELOW
$mysqlDatabaseName ='test';
$mysqlUserName ='root';
$mysqlPassword ='';
$mysqlHostName ='localhost';
$mysqlImportFilename ='dbbackupmember.sql';
//DONT EDIT BELOW THIS LINE
//Export the database and output the status to the page
$command='mysql -h' .$mysqlHostName .' -u' .$mysqlUserName .' -p' .$mysqlPassword .' ' .$mysqlDatabaseName .' &lt; ' .$mysqlImportFilename;
$output=array();
exec($command,$output,$worked);
switch($worked){
    case 0:
        echo 'Import file &lt;b&gt;' .$mysqlImportFilename .'&lt;/b&gt; successfully imported to database &lt;b&gt;' .$mysqlDatabaseName .'&lt;/b&gt;';
        break;
    case 1:
        echo 'There was an error during import.';
        break;
}
?&gt; 
</code></pre>


blocks|key|203513|text|<?php
system('mysql+--user=USER+--password=PASSWORD+DATABASE<+FOLDER/.sql');
?>|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|203514|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>&lt;?php
system('mysql --user=USER --password=PASSWORD DATABASE&lt; FOLDER/.sql');
?&gt;
</code></pre>


blocks|key|203533|text|<?php
$host+=+"localhost";
$uname+=+"root";
$pass+=+"";
$database+=+"demo1";+//Change+Your+Database+Name
$conn+=+new+mysqli($host,+$uname,+$pass,+$database);
$filename+=+'users.sql';+//How+to+Create+SQL+File+Step+:+url:http://localhost/phpmyadmin->detabase+select->table+select->Export(In+Upper+Toolbar)->Go:DOWNLOAD+.SQL+FILE
$op_data+=+'';
$lines+=+file($filename);
foreach+($lines+as+$line)
{
++++if+(substr($line,+0,+2)+==+'--'+%7C%7C+$line+==+'')//This+IF+Remove+Comment+Inside+SQL+FILE
++++{
++++++++continue;
++++}
++++$op_data+.=+$line;
++++if+(substr(trim($line),+-1,+1)+==+';')//Breack+Line+Upto+';'+NEW+QUERY
++++{
++++++++$conn->query($op_data);
++++++++$op_data+=+'';
++++}
}
echo+"Table+Created+Inside+"+.+$database+.+"+Database.......";
?>|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|203534|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>&lt;?php
$host = "localhost";
$uname = "root";
$pass = "";
$database = "demo1"; //Change Your Database Name
$conn = new mysqli($host, $uname, $pass, $database);
$filename = 'users.sql'; //How to Create SQL File Step : url:http://localhost/phpmyadmin-&gt;detabase select-&gt;table select-&gt;Export(In Upper Toolbar)-&gt;Go:DOWNLOAD .SQL FILE
$op_data = '';
$lines = file($filename);
foreach ($lines as $line)
{
    if (substr($line, 0, 2) == '--' || $line == '')//This IF Remove Comment Inside SQL FILE
    {
        continue;
    }
    $op_data .= $line;
    if (substr(trim($line), -1, 1) == ';')//Breack Line Upto ';' NEW QUERY
    {
        $conn-&gt;query($op_data);
        $op_data = '';
    }
}
echo "Table Created Inside " . $database . " Database.......";
?&gt;
</code></pre>


blocks|key|203547|text|我使用以下代码并完全运行SUCCESS：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|203548|$filename+=+'apptoko-2016-12-23.sql';+//change+to+ur+.sql+file
++++++++++++++++++++++++++++$handle+=+fopen($filename,+"r%2B");
++++++++++++++++++++++++++++$contents+=+fread($handle,+filesize($filename));

++++++++++++++++++++++++++++$sql+=+explode(";",$contents);//+
++++++++++++++++++++++++++++foreach($sql+as+$query){
++++++++++++++++++++++++++++++++$result=mysql_query($query);
++++++++++++++++++++++++++++++++if+($result){
+++++++++++++++++++++++++++++++++echo+'<tr><td><BR></td></tr>';
+++++++++++++++++++++++++++++++++echo+'<tr><td>'+.+$query+.+'+<b>SUCCESS</b></td></tr>';
+++++++++++++++++++++++++++++++++echo+'<tr><td><BR></td></tr>';
++++++++++++++++++++++++++++++++}
++++++++++++++++++++++++++++}
++++++++++++++++++++++++++++fclose($handle);|code-block|syntax|javascript|203549|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

<p>I use this code and RUN SUCCESS FULL:</p>

<pre><code>$filename = 'apptoko-2016-12-23.sql'; //change to ur .sql file
                            $handle = fopen($filename, "r+");
                            $contents = fread($handle, filesize($filename));

                            $sql = explode(";",$contents);// 
                            foreach($sql as $query){
                                $result=mysql_query($query);
                                if ($result){
                                 echo '&lt;tr&gt;&lt;td&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;';
                                 echo '&lt;tr&gt;&lt;td&gt;' . $query . ' &lt;b&gt;SUCCESS&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;';
                                 echo '&lt;tr&gt;&lt;td&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;';
                                }
                            }
                            fclose($handle);
</code></pre>


blocks|key|4709399|text|//+Import+data+
$filename+=+'database_file_name.sql';
import_tables('localhost','root','','database_name',$filename);

function+import_tables($host,$uname,$pass,$database,+$filename,$tables+=+'*'){
++++$connection+=+mysqli_connect($host,$uname,$pass)
++++or+die("Database+Connection+Failed");
++++$selectdb+=+mysqli_select_db($connection,+$database)+or+die("Database+could+not+be+selected");+

$templine+=+'';
$lines+=+file($filename);+//+Read+entire+file

foreach+($lines+as+$line){
++++//+Skip+it+if+it's+a+comment
++++if+(substr($line,+0,+2)+==+'--'+%7C%7C+$line+==+''+%7C%7C+substr($line,+0,+2)+==+'/*'+)
++++++++continue;

++++++++//+Add+this+line+to+the+current+segment
++++++++$templine+.=+$line;
++++++++//+If+it+has+a+semicolon+at+the+end,+it's+the+end+of+the+query
++++++++if+(substr(trim($line),+-1,+1)+==+';')
++++++++{
++++++++++++mysqli_query($connection,+$templine)
++++++++++++or+print('Error+performing+query+\'<strong>'+.+$templine+.+'\':+'+.+mysqli_error($connection)+.+'<br+/><br+/>');
++++++++++++$templine+=+'';
++++++++}
++++}
++++echo+"Tables+imported+successfully";
}




//+Backup+database+from+php+script
backup_tables('hostname','UserName','pass','databses_name');

function+backup_tables($host,$user,$pass,$name,$tables+=+'*'){
++++$link+=+mysqli_connect($host,$user,$pass);
++++if+(mysqli_connect_errno()){
++++++++echo+"Failed+to+connect+to+MySQL:+"+.+mysqli_connect_error();
++++}

++++mysqli_select_db($link,$name);
++++//get+all+of+the+tables
++++if($tables+==+'*'){
++++++++$tables+=+array();
++++++++$result+=+mysqli_query($link,'SHOW+TABLES');
++++++++while($row+=+mysqli_fetch_row($result))
++++++++{
++++++++++++$tables[]+=+$row[0];
++++++++}
++++}else{
++++++++$tables+=+is_array($tables)+?+$tables+:+explode(',',$tables);
++++}

++++$return+=+'';
++++foreach($tables+as+$table)
++++{
++++++++$result+=+mysqli_query($link,'SELECT+*+FROM+'.$table);
++++++++$num_fields+=+mysqli_num_fields($result);
++++++++$row_query+=+mysqli_query($link,'SHOW+CREATE+TABLE+'.$table);
++++++++$row2+=+mysqli_fetch_row($row_query);
++++++++$return.=+"\n\n".$row2[1].";\n\n";

++++++++for+($i+=+0;+$i+<+$num_fields;+$i%2B%2B)+
++++++++{
++++++++++++while($row+=+mysqli_fetch_row($result))
++++++++++++{
++++++++++++++++$return.=+'INSERT+INTO+'.$table.'+VALUES(';
++++++++++++++++for($j=0;+$j+<+$num_fields;+$j%2B%2B)+
++++++++++++++++{
++++++++++++++++++++$row[$j]+=+addslashes($row[$j]);
++++++++++++++++++++$row[$j]+=+str_replace("\n",+'\n',+$row[$j]);
++++++++++++++++++++if+(isset($row[$j]))+{+
++++++++++++++++++++++++$return.=+'"'.$row[$j].'"'+;+
++++++++++++++++++++}+else+{+
++++++++++++++++++++++++$return.=+'""';+
++++++++++++++++++++}
++++++++++++++++++++if+($j+<+($num_fields-1))+{+$return.=+',';+}
++++++++++++++++}
++++++++++++++++$return.=+");\n";
++++++++++++}
++++++++}
++++++++$return.="\n\n\n";
++++}

++++//save+file
++++$handle+=+fopen('backup-'.date("d_m_Y__h_i_s_A").'-'.(md5(implode(',',$tables))).'.sql','w%2B');
++++fwrite($handle,$return);
++++fclose($handle);
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4709400|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>// Import data 
$filename = 'database_file_name.sql';
import_tables('localhost','root','','database_name',$filename);

function import_tables($host,$uname,$pass,$database, $filename,$tables = '*'){
    $connection = mysqli_connect($host,$uname,$pass)
    or die("Database Connection Failed");
    $selectdb = mysqli_select_db($connection, $database) or die("Database could not be selected"); 

$templine = '';
$lines = file($filename); // Read entire file

foreach ($lines as $line){
    // Skip it if it's a comment
    if (substr($line, 0, 2) == '--' || $line == '' || substr($line, 0, 2) == '/*' )
        continue;

        // Add this line to the current segment
        $templine .= $line;
        // If it has a semicolon at the end, it's the end of the query
        if (substr(trim($line), -1, 1) == ';')
        {
            mysqli_query($connection, $templine)
            or print('Error performing query \'&lt;strong&gt;' . $templine . '\': ' . mysqli_error($connection) . '&lt;br /&gt;&lt;br /&gt;');
            $templine = '';
        }
    }
    echo "Tables imported successfully";
}




// Backup database from php script
backup_tables('hostname','UserName','pass','databses_name');

function backup_tables($host,$user,$pass,$name,$tables = '*'){
    $link = mysqli_connect($host,$user,$pass);
    if (mysqli_connect_errno()){
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

    mysqli_select_db($link,$name);
    //get all of the tables
    if($tables == '*'){
        $tables = array();
        $result = mysqli_query($link,'SHOW TABLES');
        while($row = mysqli_fetch_row($result))
        {
            $tables[] = $row[0];
        }
    }else{
        $tables = is_array($tables) ? $tables : explode(',',$tables);
    }

    $return = '';
    foreach($tables as $table)
    {
        $result = mysqli_query($link,'SELECT * FROM '.$table);
        $num_fields = mysqli_num_fields($result);
        $row_query = mysqli_query($link,'SHOW CREATE TABLE '.$table);
        $row2 = mysqli_fetch_row($row_query);
        $return.= "\n\n".$row2[1].";\n\n";

        for ($i = 0; $i &lt; $num_fields; $i++) 
        {
            while($row = mysqli_fetch_row($result))
            {
                $return.= 'INSERT INTO '.$table.' VALUES(';
                for($j=0; $j &lt; $num_fields; $j++) 
                {
                    $row[$j] = addslashes($row[$j]);
                    $row[$j] = str_replace("\n", '\n', $row[$j]);
                    if (isset($row[$j])) { 
                        $return.= '"'.$row[$j].'"' ; 
                    } else { 
                        $return.= '""'; 
                    }
                    if ($j &lt; ($num_fields-1)) { $return.= ','; }
                }
                $return.= ");\n";
            }
        }
        $return.="\n\n\n";
    }

    //save file
    $handle = fopen('backup-'.date("d_m_Y__h_i_s_A").'-'.(md5(implode(',',$tables))).'.sql','w+');
    fwrite($handle,$return);
    fclose($handle);
}
</code></pre>


blocks|key|203617|text|解决方案特殊字符|type|unstyled|depth|inlineStyleRanges|entityRanges|data|203618|+$link=mysql_connect($dbHost,+$dbUser,+$dbPass)+OR+die('connecting+to+host:+'.$dbHost.'+failed:+'.mysql_error());
mysql_select_db($dbName)+OR+die('select+db:+'.$dbName.'+failed:+'.mysql_error());

//charset+important
mysql_set_charset('utf8',$link);|code-block|syntax|javascript|203619|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

<p>Solution special chars</p>

<pre><code> $link=mysql_connect($dbHost, $dbUser, $dbPass) OR die('connecting to host: '.$dbHost.' failed: '.mysql_error());
mysql_select_db($dbName) OR die('select db: '.$dbName.' failed: '.mysql_error());

//charset important
mysql_set_charset('utf8',$link);
</code></pre>


blocks|key|4709494|text|Grain脚本很棒，拯救了我的一天。同时，mysql也在贬值，我用PDO重写了Grain+answer。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4709495|++++$server++=++'localhost';+
++++$username+++=+'root';+
++++$password+++=+'your+password';++
++++$database+=+'sample_db';

++++/*+PDO+connection+start+*/
++++$conn+=+new+PDO("mysql:host=$server;+dbname=$database",+$username,+$password);
++++$conn->setAttribute(PDO::ATTR_ERRMODE,+PDO::ERRMODE_EXCEPTION);+++++++++
++++$conn->exec("SET+CHARACTER+SET+utf8");+++++
++++/*+PDO+connection+end+*/

++++//+your+config
++++$filename+=+'yourFile.sql';

++++$maxRuntime+=+8;+//+less+then+your+max+script+execution+limit


++++$deadline+=+time()%2B$maxRuntime;+
++++$progressFilename+=+$filename.'_filepointer';+//+tmp+file+for+progress
++++$errorFilename+=+$filename.'_error';+//+tmp+file+for+erro



++++($fp+=+fopen($filename,+'r'))+OR+die('failed+to+open+file:'.$filename);

++++//+check+for+previous+error
++++if(+file_exists($errorFilename)+){
++++++++die('<pre>+previous+error:+'.file_get_contents($errorFilename));
++++}

++++//+activate+automatic+reload+in+browser
++++echo+'<html><head>+<meta+http-equiv="refresh"+content="'.($maxRuntime%2B2).'"><pre>';

++++//+go+to+previous+file+position
++++$filePosition+=+0;
++++if(+file_exists($progressFilename)+){
++++++++$filePosition+=+file_get_contents($progressFilename);
++++++++fseek($fp,+$filePosition);
++++}

++++$queryCount+=+0;
++++$query+=+'';
++++while(+$deadline>time()+AND+($line=fgets($fp,+1024000))+){
++++++++if(substr($line,0,2)=='--'+OR+trim($line)==''+){
++++++++++++continue;
++++++++}

++++++++$query+.=+$line;
++++++++if(+substr(trim($query),-1)==';'+){

++++++++++++$igweze_prep=+$conn->prepare($query);

++++++++++++if(!($igweze_prep->execute())){+
++++++++++++++++$error+=+'Error+performing+query+\'<strong>'+.+$query+.+'\':+'+.+print_r($conn->errorInfo());
++++++++++++++++file_put_contents($errorFilename,+$error."\n");
++++++++++++++++exit;
++++++++++++}
++++++++++++$query+=+'';
++++++++++++file_put_contents($progressFilename,+ftell($fp));+//+save+the+current+file+position+for+
++++++++++++$queryCount%2B%2B;
++++++++}
++++}

++++if(+feof($fp)+){
++++++++echo+'dump+successfully+restored!';
++++}else{
++++++++echo+ftell($fp).'/'.filesize($filename).'+'.(round(ftell($fp)/filesize($filename),+2)*100).'%25'."\n";
++++++++echo+$queryCount.'+queries+processed!+please+reload+or+wait+for+automatic+browser+refresh!';
++++}|code-block|syntax|javascript|4709496|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

<p>Grain Script is superb and save my day. Meanwhile mysql is depreciated and I rewrote Grain answer using PDO.</p>

<pre><code>    $server  =  'localhost'; 
    $username   = 'root'; 
    $password   = 'your password';  
    $database = 'sample_db';

    /* PDO connection start */
    $conn = new PDO("mysql:host=$server; dbname=$database", $username, $password);
    $conn-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);         
    $conn-&gt;exec("SET CHARACTER SET utf8");     
    /* PDO connection end */

    // your config
    $filename = 'yourFile.sql';

    $maxRuntime = 8; // less then your max script execution limit


    $deadline = time()+$maxRuntime; 
    $progressFilename = $filename.'_filepointer'; // tmp file for progress
    $errorFilename = $filename.'_error'; // tmp file for erro



    ($fp = fopen($filename, 'r')) OR die('failed to open file:'.$filename);

    // check for previous error
    if( file_exists($errorFilename) ){
        die('&lt;pre&gt; previous error: '.file_get_contents($errorFilename));
    }

    // activate automatic reload in browser
    echo '&lt;html&gt;&lt;head&gt; &lt;meta http-equiv="refresh" content="'.($maxRuntime+2).'"&gt;&lt;pre&gt;';

    // go to previous file position
    $filePosition = 0;
    if( file_exists($progressFilename) ){
        $filePosition = file_get_contents($progressFilename);
        fseek($fp, $filePosition);
    }

    $queryCount = 0;
    $query = '';
    while( $deadline&gt;time() AND ($line=fgets($fp, 1024000)) ){
        if(substr($line,0,2)=='--' OR trim($line)=='' ){
            continue;
        }

        $query .= $line;
        if( substr(trim($query),-1)==';' ){

            $igweze_prep= $conn-&gt;prepare($query);

            if(!($igweze_prep-&gt;execute())){ 
                $error = 'Error performing query \'&lt;strong&gt;' . $query . '\': ' . print_r($conn-&gt;errorInfo());
                file_put_contents($errorFilename, $error."\n");
                exit;
            }
            $query = '';
            file_put_contents($progressFilename, ftell($fp)); // save the current file position for 
            $queryCount++;
        }
    }

    if( feof($fp) ){
        echo 'dump successfully restored!';
    }else{
        echo ftell($fp).'/'.filesize($filename).' '.(round(ftell($fp)/filesize($filename), 2)*100).'%'."\n";
        echo $queryCount.' queries processed! please reload or wait for automatic browser refresh!';
    }
</code></pre>


blocks|key|203684|text|可以使用mysqli+multi_query函数，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|203685|$sql+=+file_get_contents('mysqldump.sql');

$mysqli+=+new+mysqli("localhost",+"root",+"pass",+"testdb");

/*+execute+multi+query+*/
$mysqli->multi_query($sql);|code-block|syntax|javascript|203686|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

<p>You can use the mysqli multi_query function as below:</p>

<pre><code>$sql = file_get_contents('mysqldump.sql');

$mysqli = new mysqli("localhost", "root", "pass", "testdb");

/* execute multi query */
$mysqli-&gt;multi_query($sql);
</code></pre>


blocks|key|4709538|text|我想你可以试试这段代码，它是针对我的情况运行的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4709539|​|4709540|<?php

$con+=+mysqli_connect('localhost',+'root',+'NOTSHOWN',+'test');

$filename+=+'dbbackupmember.sql';
$handle+=+fopen($filename,+'r%2B');
$contents+=+fread($handle,+filesize($filename));

$sql+=+explode(";",+$contents);
foreach+($sql+as+$query)+{
	$result+=+mysqli_query($con,+$query);
	if+($result)+{
		echo+"<tr><td><br></td></tr>";
		echo+"<tr><td>".$query."</td></tr>";
		echo+"<tr><td><br></td></tr>";
	}
}

fclose($handle);
echo+"success";


?>|code-block|syntax|javascript|4709541|4709542|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|N|8|@]|9|@]|A|$G|H]]|$1|I|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|P|8|@]|9|@]|A|$]]]|K|$]]

<p>I Thing you can Try this Code, It's Run for my Case:</p>

<p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;?php

$con = mysqli_connect('localhost', 'root', 'NOTSHOWN', 'test');

$filename = 'dbbackupmember.sql';
$handle = fopen($filename, 'r+');
$contents = fread($handle, filesize($filename));

$sql = explode(";", $contents);
foreach ($sql as $query) {
	$result = mysqli_query($con, $query);
	if ($result) {
		echo "&lt;tr&gt;&lt;td&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;";
		echo "&lt;tr&gt;&lt;td&gt;".$query."&lt;/td&gt;&lt;/tr&gt;";
		echo "&lt;tr&gt;&lt;td&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;";
	}
}

fclose($handle);
echo "success";


?&gt;</code></pre>
</div>
</div>
</p>


blocks|key|4709568|text|function+restoreDatabase($db_name,$file_path)
{

++++//checking+valid+extension+file
++++$path_parts+=+pathinfo($file_path);
++++$ext_file+=+$path_parts['extension'];
++++$filename+=+$path_parts['basename'];

++++if($ext_file+==+"sql")
++++{
+++++++++$c+=+new+Config();

+++++++++$confJson+=+$c->getConfig();
+++++++++$conf+=+json_decode($confJson);

+++++++++$dbhost+++=+"127.0.0.1";
+++++++++$dbuser+++=+$conf->db_username;++
+++++++++$dbpwd++++=+$conf->db_password;
+++++++++$dbname+++=+$db_name;+++

+++++++++$dumpfile+=+$file_path;

+++++++++$is_file+=+file_exists($file_path);
+++++++++if($is_file+==+TRUE)
+++++++++{

+++++++++++++//passthru("/usr/bin/mysqldump+--opt+--host=$dbhost+--user=$dbuser+--password=$dbpwd+$dbname+<+$dumpfile");

+++++++++++++//passthru("tail+-1+$dumpfile");
+++++++++++++system('mysql+--user='.$dbuser.'+--password='.$dbpwd.'+'.$db_name.'+<+'.$file_path);
+++++++++++++return+"Database+was+restored+from+$filename+";

+++++++++}
+++++++++else+
+++++++++{
+++++++++++++return+"Restore+database+was+aborted+due+".$filename."+does+not+exist!";
+++++++++}


++++}
++++else
++++{
++++++++return+"Invalid+file+format.Require+sql+file+to+restore+this+".$db_name."+database.+".$filename."+is+not+sql+file+format\n(eg.+mybackupfile.sql).";
++++}
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4709569|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>function restoreDatabase($db_name,$file_path)
{

    //checking valid extension file
    $path_parts = pathinfo($file_path);
    $ext_file = $path_parts['extension'];
    $filename = $path_parts['basename'];

    if($ext_file == "sql")
    {
         $c = new Config();

         $confJson = $c-&gt;getConfig();
         $conf = json_decode($confJson);

         $dbhost   = "127.0.0.1";
         $dbuser   = $conf-&gt;db_username;  
         $dbpwd    = $conf-&gt;db_password;
         $dbname   = $db_name;   

         $dumpfile = $file_path;

         $is_file = file_exists($file_path);
         if($is_file == TRUE)
         {

             //passthru("/usr/bin/mysqldump --opt --host=$dbhost --user=$dbuser --password=$dbpwd $dbname &lt; $dumpfile");

             //passthru("tail -1 $dumpfile");
             system('mysql --user='.$dbuser.' --password='.$dbpwd.' '.$db_name.' &lt; '.$file_path);
             return "Database was restored from $filename ";

         }
         else 
         {
             return "Restore database was aborted due ".$filename." does not exist!";
         }


    }
    else
    {
        return "Invalid file format.Require sql file to restore this ".$db_name." database. ".$filename." is not sql file format\n(eg. mybackupfile.sql).";
    }
}
</code></pre>


blocks|key|203746|text|如果你需要一个用户界面，如果你想使用PDO|type|unstyled|depth|inlineStyleRanges|entityRanges|data|203747|这里有一个简单的解决方案|203748|<form+method="post"+enctype="multipart/form-data">
++++<input+type="text"+name="db"+placeholder="Databasename"+/>
++++<input+type="file"+name="file">
++++<input+type="submit"+name="submit"+value="submit">
</form>

<?php

if(isset($_POST['submit'])){
++++$query+=+file_get_contents($_FILES["file"]["name"]);
++++$dbname+=+$_POST['db'];
++++$con+=+new+PDO("mysql:host=localhost;dbname=$dbname","root","");
++++$stmt+=+$con->prepare($query);
++++if($stmt->execute()){
++++++++echo+"Successfully+imported+to+the+$dbname.";
++++}
}
?>|code-block|syntax|javascript|203749|对我来说绝对是有帮助的。值得一试。|203750|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<h2>If you need a User Interface and if you want to use PDO</h2>

<p>Here's a simple solution</p>

<pre><code>&lt;form method="post" enctype="multipart/form-data"&gt;
    &lt;input type="text" name="db" placeholder="Databasename" /&gt;
    &lt;input type="file" name="file"&gt;
    &lt;input type="submit" name="submit" value="submit"&gt;
&lt;/form&gt;

&lt;?php

if(isset($_POST['submit'])){
    $query = file_get_contents($_FILES["file"]["name"]);
    $dbname = $_POST['db'];
    $con = new PDO("mysql:host=localhost;dbname=$dbname","root","");
    $stmt = $con-&gt;prepare($query);
    if($stmt-&gt;execute()){
        echo "Successfully imported to the $dbname.";
    }
}
?&gt;
</code></pre>

<p>Definitely working on my end. Worth a try.</p>


blocks|key|4709586|text|众所周知，MySQL在PHP5.5.0中被弃用，在PHP7.0.0中被删除，因此我将接受的answer转换为ref。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4709587|<?php
//+Name+of+the+file
$filename+=+'db.sql';
//+MySQL+host
$mysql_host+=+'localhost';
//+MySQL+username
$mysql_username+=+'root';
//+MySQL+password
$mysql_password+=+'123456';
//+Database+name
$mysql_database+=+'mydb';

$connection+=+mysqli_connect($mysql_host,$mysql_username,$mysql_password,$mysql_database)+or+die(mysqli_error($connection));

//+Temporary+variable,+used+to+store+current+query
$templine+=+'';
//+Read+in+entire+file
$lines+=+file($filename);
//+Loop+through+each+line
foreach+($lines+as+$line)
{
//+Skip+it+if+it's+a+comment
if+(substr($line,+0,+2)+==+'--'+%7C%7C+$line+==+'')
++++continue;

//+Add+this+line+to+the+current+segment
$templine+.=+$line;
//+If+it+has+a+semicolon+at+the+end,+it's+the+end+of+the+query
if+(substr(trim($line),+-1,+1)+==+';')
{
++++//+Perform+the+query
++++mysqli_query($connection,$templine)+or+print('Error+performing+query+\'<strong>'+.+$templine+.+'\':+'+.+mysqli_error($connection)+.+'<br+/><br+/>');
++++//+Reset+temp+variable+to+empty
++++$templine+=+'';
}
}
+echo+"Tables+imported+successfully";
?>|code-block|syntax|javascript|4709588|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/19752106/815003|1|https://www.php.net/manual/en/function.mysql-connect.php^0|19|6|0|1I|3|1|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]|$A|W|B|X|1|Y]]|C|$]]|$1|D|3|E|5|F|7|Z|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|10|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]|Q|$5|L|M|N|C|$O|R]]]]

<p>As we all know MySQL was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0 <a href="https://www.php.net/manual/en/function.mysql-connect.php" rel="nofollow noreferrer">ref</a> so I have converted accepted <a href="https://stackoverflow.com/a/19752106/815003">answer</a> to mysqli.</p>

<pre><code>&lt;?php
// Name of the file
$filename = 'db.sql';
// MySQL host
$mysql_host = 'localhost';
// MySQL username
$mysql_username = 'root';
// MySQL password
$mysql_password = '123456';
// Database name
$mysql_database = 'mydb';

$connection = mysqli_connect($mysql_host,$mysql_username,$mysql_password,$mysql_database) or die(mysqli_error($connection));

// Temporary variable, used to store current query
$templine = '';
// Read in entire file
$lines = file($filename);
// Loop through each line
foreach ($lines as $line)
{
// Skip it if it's a comment
if (substr($line, 0, 2) == '--' || $line == '')
    continue;

// Add this line to the current segment
$templine .= $line;
// If it has a semicolon at the end, it's the end of the query
if (substr(trim($line), -1, 1) == ';')
{
    // Perform the query
    mysqli_query($connection,$templine) or print('Error performing query \'&lt;strong&gt;' . $templine . '\': ' . mysqli_error($connection) . '&lt;br /&gt;&lt;br /&gt;');
    // Reset temp variable to empty
    $templine = '';
}
}
 echo "Tables imported successfully";
?&gt;
</code></pre>


blocks|key|4709617|text|如果您使用PHP版本7或更高版本，请尝试以下脚本，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4709618|//+Name+of+the+file
$filename+=+'sql.sql';
//+MySQL+host
$mysql_host+=+'localhost';
//+MySQL+username
$mysql_username+=+'username';
//+MySQL+password
$mysql_password+=+'password';
//+Database+name
$mysql_database+=+'database';
//+Connect+to+MySQL+server
$con+=+@new+mysqli($mysql_host,$mysql_username,$mysql_password,$mysql_database);
//+Check+connection
if+($con->connect_errno)+{
+++echo+"Failed+to+connect+to+MySQL:+"+.+$con->connect_errno;
+++echo+"<br/>Error:+"+.+$con->connect_error;
}
//+Temporary+variable,+used+to+store+current+query
$templine+=+'';
//+Read+in+entire+file
$lines+=+file($filename);
//+Loop+through+each+line
foreach+($lines+as+$line)+{
//+Skip+it+if+it's+a+comment
if+(substr($line,+0,+2)+==+'--'+%7C%7C+$line+==+'')
++++continue;
//+Add+this+line+to+the+current+segment
$templine+.=+$line;
//+If+it+has+a+semicolon+at+the+end,+it's+the+end+of+the+query
if+(substr(trim($line),+-1,+1)+==+';')+{
//+Perform+the+query
$con->query($templine)+or+print('Error+performing+query+\'<strong>'+.+$templine+.+'\':+'+.+$con->error()+.+'<br+/><br+/>');
++++//+Reset+temp+variable+to+empty
++++$templine+=+'';
}
}
echo+"Tables+imported+successfully";
$con->close($con);|code-block|syntax|javascript|4709619|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

<p>If you are using PHP version 7 or higher, try below script,</p>

<pre><code>// Name of the file
$filename = 'sql.sql';
// MySQL host
$mysql_host = 'localhost';
// MySQL username
$mysql_username = 'username';
// MySQL password
$mysql_password = 'password';
// Database name
$mysql_database = 'database';
// Connect to MySQL server
$con = @new mysqli($mysql_host,$mysql_username,$mysql_password,$mysql_database);
// Check connection
if ($con-&gt;connect_errno) {
   echo "Failed to connect to MySQL: " . $con-&gt;connect_errno;
   echo "&lt;br/&gt;Error: " . $con-&gt;connect_error;
}
// Temporary variable, used to store current query
$templine = '';
// Read in entire file
$lines = file($filename);
// Loop through each line
foreach ($lines as $line) {
// Skip it if it's a comment
if (substr($line, 0, 2) == '--' || $line == '')
    continue;
// Add this line to the current segment
$templine .= $line;
// If it has a semicolon at the end, it's the end of the query
if (substr(trim($line), -1, 1) == ';') {
// Perform the query
$con-&gt;query($templine) or print('Error performing query \'&lt;strong&gt;' . $templine . '\': ' . $con-&gt;error() . '&lt;br /&gt;&lt;br /&gt;');
    // Reset temp variable to empty
    $templine = '';
}
}
echo "Tables imported successfully";
$con-&gt;close($con);
</code></pre>


<p>I'm trying to import a .sql file through PHP code. However, my code shows this error:</p>

<pre><code>There was an error during import. Please make sure the import file is saved in the same folder as this script and check your values:

MySQL Database Name:    test
MySQL User Name:    root
MySQL Password: NOTSHOWN
MySQL Host Name:    localhost
MySQL Import Filename:  dbbackupmember.sql
</code></pre>

<p>And this is my code:</p>

<pre><code>&lt;?php
//ENTER THE RELEVANT INFO BELOW
$mysqlDatabaseName ='test';
$mysqlUserName ='root';
$mysqlPassword ='';
$mysqlHostName ='localhost';
$mysqlImportFilename ='dbbackupmember.sql';
//DONT EDIT BELOW THIS LINE
//Export the database and output the status to the page
$command='mysql -h' .$mysqlHostName .' -u' .$mysqlUserName .' -p' .$mysqlPassword .' ' .$mysqlDatabaseName .' &lt; ' .$mysqlImportFilename;
exec($command,$output=array(),$worked);
switch($worked){
    case 0:
        echo 'Import file &lt;b&gt;' .$mysqlImportFilename .'&lt;/b&gt; successfully imported to database &lt;b&gt;' .$mysqlDatabaseName .'&lt;/b&gt;';
        break;
    case 1:
        echo 'There was an error during import. Please make sure the import file is saved in the same folder as this script and check your values:&lt;br/&gt;&lt;br/&gt;&lt;table&gt;&lt;tr&gt;&lt;td&gt;MySQL Database Name:&lt;/td&gt;&lt;td&gt;&lt;b&gt;' .$mysqlDatabaseName .'&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;MySQL User Name:&lt;/td&gt;&lt;td&gt;&lt;b&gt;' .$mysqlUserName .'&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;MySQL Password:&lt;/td&gt;&lt;td&gt;&lt;b&gt;NOTSHOWN&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;MySQL Host Name:&lt;/td&gt;&lt;td&gt;&lt;b&gt;' .$mysqlHostName .'&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;MySQL Import Filename:&lt;/td&gt;&lt;td&gt;&lt;b&gt;' .$mysqlImportFilename .'&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;';
        break;
}
?&gt;
</code></pre>

<p>What am I doing wrong? The SQL file is in the same directory.</p>


How do I import a .sql file in mysql database using PHP?

数据库

MySQL

我正在尝试通过PHP代码导入一个.sql文件。但是，我的代码显示以下错误：There was an error during import. Please make sure the import file is saved in the same folder as this script and check you...

问如何使用PHP在mysql数据库中导入.sql文件？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用PHP在mysql数据库中导入.sql文件？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用PHP在mysql数据库中导入.sql文件？
EN