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
268 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
9 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

726 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