MySQL: SELECT from another server
You can set up federated tables in MySQL to accomplish what you’re trying to do. There are some limitations. http://dev.mysql.com/doc/refman/en/federated-storage-engine.html http://dev.mysql.com/doc/refman/en/federated-usagenotes.html