MYSQL:从2个数据库中复制表的数据.两个数据库都位于不同的服务器(托管公司)中 [英] MYSQL : Copy data of tables from 2 databases. Both database are in different servers(Hosting companies)

问题描述

我有一个应用程序，可以从托管公司myhosting.com中的数据库表中复制数据.

I have an application where I copy data from a table of database which is in hosting company myhosting.com.

我需要将此数据复制到托管公司inmotionhosting.com中数据库的另一个表中

I need to copy this data to another table of a database which is in a hosting company inmotionhosting.com

它基本上是从两个位于不同托管公司的2个表中复制数据. 这两个数据库都是mysql，我在两个数据库中都拥有完全权限.

It is basically copying data from 2 tables which are in two different hosting company. Both the database are mysql and I have full rights in both the databases.

我知道我们可以下载整个数据库并在另一个托管公司中上载数据库，但这不能解决我的目的.

I know that we can download entire database and upload the database in another hosting company but it does not solve my purpose.

推荐答案

在PHP中，这应该非常容易.只需建立多个连接($ link1，$ link2等)-每个服务器一个.从$ link1中的表中选择数据，然后在$ link2中将其插入(或更新).

This should be very easy in PHP. Just make multiple connections ($link1, $link2, etc.) - one to each server. SELECT data from a table in $link1 and INSERT (or UPDATE) it in $link2.

唯一的问题是，托管公司通常默认情况下只会为本地服务器打开MySQL端口(通常为3306).如果真是这样，那么如果您的程序在服务器A上运行，则它可以毫无问题地连接到服务器A上的MySQL，但不能连接到服务器B上的MySQL.应该在服务器控制面板中提供一种简单的打开方法设置端口3306进行远程访问-如果没有，则必须要求托管公司(其中一个)为您执行此操作.

The only catch is that often a hosting company will only, by default, open MySQL port (normally 3306) for the local server. If that is the case, then if your program is running on server A then it will be able to connect to MySQL on server A without a problem but not MySQL on server B. There should be an easy way in the server control panel to open up port 3306 for remote access - if not then you will have to ask the hosting company (one of them) to do that for you.

这篇关于MYSQL:从2个数据库中复制表的数据.两个数据库都位于不同的服务器(托管公司)中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！