mysql 将数据库转移到新服务器_mysql – 将多个数据库移动到新服务器的最快方法...

我对cPanel知之甚少,但我知道如何快速地将数据库传输到另一台服务器 – 如果你有权访问ssh.

使用带有正确参数的mysqldump并将其与ssh链接.所以在sorce数据库仍然导出时导入数据库.没有使用临时文件(内部mysql除外;))

sourceserver#

mysqldump –user = user1 –all-databases | ssh targethost’mysql –user = user2′

如果使用私钥和ssh-agent对源服务器进行身份验证,则可以使用ssh的-A选项进行连接.因此,您无需关心目标方面的授权.但请记住：

Agent forwarding should be enabled with caution. Users with the

ability to bypass file permissions on the remote host (for the

agent's Unix-domain socket) can access the local agent through

the forwarded connection. An attacker cannot obtain key material

from the agent, however they can perform operations on the keys

that enable them to authenticate using the identities loaded into

the agent.

(来源：man 1 ssh)

希望这个对你有帮助