title: MySQL Cross Server Select Query
body: <p>Is it possible to write a cross server select query using MySQL Client. Basically the setup is like follows.</p>
  
  <p>Server IP  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;        Database<br>
  ---------  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;        --------<br>
  1.2.3.4    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;        Test<br>
  a.b.c.d    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;        Test</p>
  
  <p>I want to write a query that will select rows from a table in the Test Database on 1.2.3.4 and insert the result in a table into the Test Database on a.b.c.d <br>
  My servers are located miles apart so I will be opening a SSH tunnel to connect the two.</p>
  
  <p>Any pointers?</p>