如何使用php将mysql DB从本地主机复制到服务器？

<?php
// 连接本地MySQL数据库
$localHost = 'localhost';
$localUsername = 'your_local_username';
$localPassword = 'your_local_password';
$localDatabase = 'your_local_database';

$localConnection = mysqli_connect($localHost, $localUsername, $localPassword, $localDatabase);

// 导出数据
$query = "SELECT * FROM your_table";
$result = mysqli_query($localConnection, $query);

$data = array();
while ($row = mysqli_fetch_assoc($result)) {
    $data[] = $row;
}

// 将数据保存到文件
$file = 'data.json';
file_put_contents($file, json_encode($data));

// 关闭连接
mysqli_close($localConnection);
?>

<?php
// 连接服务器上的MySQL数据库
$serverHost = 'server_host';
$serverUsername = 'your_server_username';
$serverPassword = 'your_server_password';
$serverDatabase = 'your_server_database';

$serverConnection = mysqli_connect($serverHost, $serverUsername, $serverPassword, $serverDatabase);

// 导入数据
$file = 'data.json';
$data = json_decode(file_get_contents($file), true);

foreach ($data as $row) {
    $columns = implode(', ', array_keys($row));
    $values = implode("', '", array_values($row));
    $query = "INSERT INTO your_table ($columns) VALUES ('$values')";
    mysqli_query($serverConnection, $query);
}

// 关闭连接
mysqli_close($serverConnection);
?>