title: Restore mysql database from a remote dump file
body: <p>Is it possible to restore a dump file from a remote server?</p>
  
  <pre><code>mysql -u root -p &lt; dump.sql
  </code></pre>
  
  <p>Can a dump.sql be located in a remote server? If so how do I refer it in the command above. Copying to the server isn't an option as there is no enough space in the server. I'm on redhat 5</p>