<div>
All the experts on the subject say mysqldump allows the dumping of &nbsp;a database to a local or remote file system<br />
as I said before it uses LOAD DATA LOCAL to and not LOCAL to grab the load file to import<br />
from a remote and local file source.<br />
e.g omit the LOCAL and it uses the remote<br />
select * from city into outfile '/mydir/city.sql' &nbsp;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
</div>


<div>
looking at the documentation, it's not possible:<br />
<a href="http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html" rel="ugc">http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html</a><br />
maybe there &quot;is&quot; something undocumented ...<br />
listening ...
</div>


<div>
There has to be something undocumented
</div>


<div>
I am still researching this for a final answer
</div>


<div>
I think I will have to check the mysqldump source code ultimately
</div>


<div>
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
</div>


<div>
ok, waiting for your findings...
</div>


<div>
no time right now I will get back on this eventually
</div>


<div>
<div class="content wysiwyg-content">
how do I asuming --local-infile=1 &nbsp;on server &nbsp;do a mysql -u -p -hremote &nbsp;dump to remote server filesystem?<br />
<br />
I need to know specific to mysqldump which definitely can dump to either local or rmote <br />
but how? what are the command line parameters<br />
I know from MySQL &nbsp; load &nbsp;data &nbsp;local infile &nbsp;reads data files from the client<br />
versus <br />
load &nbsp;data &nbsp;infile &nbsp;reads data files from the remote file system <br />
mysqlimport does this via the --local &nbsp; option but no --local or --remote appears to exist for mysqldump &nbsp;so how does mysqldump get this done? assuming complete control of system MySQLD server variables???<br />
<br />
note the remote specified is any remotehost xyz.mydom.com and -u -p &nbsp;just were user and password left blank could have written -umyuser -pmypasswd
</div>
</div>


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

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

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.