Avatar of Robert Silver
Robert SilverFlag for United States of America asked on

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

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
MySQL Server

Avatar of undefined
Last Comment
Robert Silver

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Guy Hengel [angelIII / a3]

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Robert Silver

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]

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 ...
ASKER
Robert Silver

There has to be something undocumented
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
Robert Silver

I am still researching this for a final answer
ASKER
Robert Silver

I think I will have to check the mysqldump source code ultimately
ASKER
Robert Silver

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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Guy Hengel [angelIII / a3]

ok, waiting for your findings...
ASKER
Robert Silver

no time right now I will get back on this eventually