• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 819
  • Last Modified:

mysqldump to remote server

Hi All,

We have a Linux server with MySQL.

I need to do a mysqldump from the Linux server to a Sun server

For a local dump, I would do mysqldump mydb > /tmp/mydb.sql
Then ftp it to the Sun server.

But this dump is rather large and there's not enough free diskspace on the Linux server.

What is the command to do a remote mysqldump (from Linux to Solaris)?

There is no mysql on Sun server, it's just used to store backups.

Please advise.

Thank you,
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
2 methods:

 mount a folder from the remote server locally, and dump to that folder
 create a system of 2 pipes, one locally which feeds the pipe on the remote server, on the remote server cat from that pipefile to a read file, and start the dump to the local pipe (sounds complex, but is only difficult to set in place if you have a high security environment)

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now