1、使用show engines;命令查看federated引擎是否开启
2、如果没开启,windows在my.ini中[mysqld]标签下下直接加上一行 federated重启数据库服务,linux在my.cnf中添加
3、开始建立:
CREATE TABLE `tablename` (
#字段部分,可直接copy远程表结构
`id` int(11) NOT NULL AUTO_INCREMENT,
`ext1` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci,
`ext2` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci ,
...
PRIMARY KEY (`id`) USING BTREE
) ENGINE=FEDERATED
CONNECTION='mysql://username:password@ip:port/远程库/远程表名';