Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2014-02-25
9
Medium Priority
?
276 Views
Last Modified: 2014-08-29
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
0
Comment
Question by:Robert Silver
  • 6
  • 3
9 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 39888414
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.
0
 
LVL 2

Author Comment

by:Robert Silver
ID: 39890481
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
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 39891229
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 ...
0
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

 
LVL 2

Author Comment

by:Robert Silver
ID: 39892412
There has to be something undocumented
0
 
LVL 2

Author Comment

by:Robert Silver
ID: 39927149
I am still researching this for a final answer
0
 
LVL 2

Author Comment

by:Robert Silver
ID: 39927152
I think I will have to check the mysqldump source code ultimately
0
 
LVL 2

Author Comment

by:Robert Silver
ID: 39931713
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
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 39934816
ok, waiting for your findings...
0
 
LVL 2

Author Comment

by:Robert Silver
ID: 39954087
no time right now I will get back on this eventually
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question