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
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
266 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 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

791 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