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
261 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 142

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 142

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
 
LVL 2

Author Comment

by:Robert Silver
ID: 39892412
There has to be something undocumented
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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 142

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

864 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now