警告：
mysql_*自PHP 5.5.0起，扩展名已弃用，自PHP
7.0.0起，扩展名已删除。相反，应使用mysqli或PDO_MySQL扩展名。另请参见MySQL
API概述，以获取选择MySQL
API时的更多帮助。
只要有可能，应将文件导入MySQL委托给MySQL客户端。
我有另一种方法可以尝试
<?php// Name of the file$filename = 'churc.sql';// MySQL host$mysql_host = 'localhost';// MySQL username$mysql_username = 'root';// MySQL password$mysql_password = '';// Database name$mysql_database = 'dump';// Connect to MySQL servermysql_connect($mysql_host, $mysql_username, $mysql_password) or die('Error connecting to MySQL server: ' . mysql_error());// Select databasemysql_select_db($mysql_database) or die('Error selecting MySQL database: ' . mysql_error());// Temporary variable, used to store current query$templine = '';// Read in entire file$lines = file($filename);// Loop through each lineforeach ($lines as $line){// Skip it if it's a commentif (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 queryif (substr(trim($line), -1, 1) == ';'){ // Perform the query mysql_query($templine) or print('Error performing query '<strong>' . $templine . '': ' . mysql_error() . '<br /><br />'); // Reset temp variable to empty $templine = '';}} echo "Tables imported successfully";?>这对我有用
