MySQL导入成功通过PhpMyAdmin导入转储文件。 但是通过PHP导入不起作用

Question

Ok, I've been pulling my hairs for few days and can't find out what's happening. I can successfully import mysql dump file through phpmyadmin but whenever I try to import it into the database using any php script it, gives me error. Currently, I'm using this script.

<?php

$mysqlDatabaseName = 'dbnname';
$mysqlUserName = 'username';
$mysqlPassword = 'password';
$mysqlHostName = 'localhost';
$mysqlImportFilename = dirname(__FILE__) . '/database.sql';
//DONT EDIT BELOW THIS LINE
//Export the database and output the status to the page
$con = mysqli_connect($mysqlHostName, $mysqlUserName, $mysqlPassword, $mysqlDatabaseName);
if (!$con) {
    die('connection failed');
}
$command = 'mysql -h' . $mysqlHostName . ' -u' . $mysqlUserName . ' -p' . $mysqlPassword . ' ' . $mysqlDatabaseName . ' < ' . $mysqlImportFilename;
$result = mysqli_query($con, $command);
if ($result) {
    print_r('True $result: ' . $result);
} else {
    print_r('False $result: ' . $result . mysqli_errno($con));
} // TODO need to print mysqli_errno

Error I'm getting when using script:-

False $result: 1064

There is no error while manually importing through phpmyadmin.

Thanks

Answer 1

The $command which you are feeding to mysqli is the call for the standalone mysql command line interface and not a mysqli function call. Use the PHP system() or similar functions to call the external mysql CLI.