how do I asuming --local-infile=1 on server do a mysql -u -p -hremote dump to remote server filesystem

Robert Silver
Robert Silver used Ask the Experts™
on
how do I asuming --local-infile=1  on server  do a mysql -u -p -hremote  dump to remote server filesystem?

I need to know specific to mysqldump which definitely can dump to either local or rmote
but how? what are the command line parameters
I know from MySQL   load  data  local infile  reads data files from the client
versus
load  data  infile  reads data files from the remote file system
mysqlimport does this via the --local   option but no --local or --remote appears to exist for mysqldump  so how does mysqldump get this done? assuming complete control of system MySQLD server variables???

note the remote specified is any remotehost xyz.mydom.com and -u -p  just were user and password left blank could have written -umyuser -pmypasswd
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
from what I can see, you cannot send the file to the server's filesystem, unless:
* you run the mysqldump on the remote server itself
* export to a folder which is mapped to the remote server itself

you will need to implement some process for the first one, or a "setup" of the mapped drive for the second option.
Robert SilverSr. Software Engineer

Author

Commented:
All the experts on the subject say mysqldump allows the dumping of  a database to a local or remote file system
as I said before it uses LOAD DATA LOCAL to and not LOCAL to grab the load file to import
from a remote and local file source.
e.g omit the LOCAL and it uses the remote
select * from city into outfile '/mydir/city.sql'  seems to store the output on the remote server of course the user must have file privileges but other than that there should be a way with mysqldump to do this and when I find it you will know. I may need to go look at the source code perhaps that will tell me
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
looking at the documentation, it's not possible:
http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
maybe there "is" something undocumented ...
listening ...
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

Robert SilverSr. Software Engineer

Author

Commented:
There has to be something undocumented
Robert SilverSr. Software Engineer

Author

Commented:
I am still researching this for a final answer
Robert SilverSr. Software Engineer

Author

Commented:
I think I will have to check the mysqldump source code ultimately
Robert SilverSr. Software Engineer

Author

Commented:
I have decided to when I get the chance go through the source code of mysqldump to determine this as the silence here indicates this may not currently be possible. I will find out for sure except perhaps as suggested via NFS or UNCs and linked folders
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
ok, waiting for your findings...
Robert SilverSr. Software Engineer

Author

Commented:
no time right now I will get back on this eventually

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial