php - 使用 PHP 脚本在 XAMPP 服务器上导入 MySQL 数据库

Question

我正在尝试使用以下脚本将一个相当大的数据库导入到我的本地服务器(XAMPP)中。

<?php
//ENTER THE RELEVANT INFO BELOW

$mysqlDatabaseName ='****';
$mysqlUserName ='****';
$mysqlPassword =*****';
$mysqlImportFilename ='05.03.2014.sql';

//DO NOT EDIT BELOW THIS LINE
$mysqlHostName ='localhost';
//Export the database and output the status to the page
$command='mysql -u' .$mysqlUserName .' -S /tmp/mysql5.sock -p' .$mysqlPassword .' '             .$mysqlDatabaseName .' < ' .$mysqlImportFilename;
exec($command,$output=array(),$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. Please make sure the import file is saved in   the same folder as this script and check your values:<br/><br/><table><tr><td>MySQL Database   Name:</td><td><b>' .$mysqlDatabaseName .'</b></td></tr><tr><td>MySQL User Name:</td><td><b>'    .$mysqlUserName .'</b></td></tr><tr><td>MySQL Password:</td><td><b>NOTSHOWN</b></td></tr><tr><td>MySQL Host Name:</td><td><b>' .$mysqlHostName .'</b></td></tr><tr><td>MySQL Import Filename:</td><td><b>' .$mysqlImportFilename .'</b></td></tr></table>';
    break;
}
?>

但是，我不断收到以下错误消息“导入期间出错。请确保导入文件与此脚本保存在同一文件夹中，并检查您的值”

我感觉主机名可能不正确 - 即/tmp/mysql5.sock

有人可以帮忙吗？

干杯

一个

Answer 1

您可以使用BigDump脚本导入大型数据库。

Use "BigDump" script