title: mysqldump backup and restore to remote server
body: <p>How can i use mysqldump to backup and restore database to a remote server?</p>
  
  <p>Both have root access. I am using putty to perform this. </p>
  
  <p>So far I tried the following:</p>
  
  <pre><code>mysqldump -u root -p &gt;z*x311a!@ masdagn_joom15 | mysql \ -u root -p g2154hE6-AsXP --host=207.210.71.26 -C masdagn_joom15temp \g
  </code></pre>
  
  <p>but it refused</p>
  
  <p>the local password is: >z*x311a!@</p>
  
  <p>the remote password is: g2154hE6-AsXP</p>