mysqldump directly to hard drive [Archive]

View Full Version : mysqldump directly to hard drive

Jake Bunce

Sat 23rd Mar '02, 3:23am

is there a way to dump a db directly onto your local hard drive through a command line to the server? (instead of dumping it on the server first and then making the local backup)

eva2000

Sat 23rd Mar '02, 3:32am

not really unless you're running a web server yourself on your on pc with your own ip

Dave#

Sat 23rd Mar '02, 7:34am

Jake Bunce

Sat 23rd Mar '02, 1:34pm

Originally posted by Dave#

Sure

Use NFS or SAMBA to dump to your workstation.

is there a freeware program for that or is it something i need to buy? or is it a command line thing?

Dave#

Sun 24th Mar '02, 2:32pm

Originally posted by Jakeman

is there a freeware program for that or is it something i need to buy? or is it a command line thing?

The very short answer is that it is the protocol by which a lot of
PC-related machines share files and printers and other informatiuon
such as lists of available files and printers. Operating systems that
support this natively include Windows NT, OS/2, and Linux and add on
packages that achieve the same thing are available for DOS, Windows,
VMS, Unix of all kinds, MVS, and more. Apple Macs and some Web Browsers
can speak this protocol as well. Alternatives to SMB include
Netware, NFS, Appletalk, Banyan Vines, Decnet etc; many of these have
advantages but none are both public specifications and widely
implemented in desktop machines by default.

http://www.samba.org/samba/about.html

kippesp

Sun 24th Mar '02, 7:28pm

Originally posted by Jakeman
is there a way to dump a db directly onto your local hard drive through a command line to the server? (instead of dumping it on the server first and then making the local backup)

See the -h option in "man mysqldump"

It is possible and I've done it many times (on linux). It requires, among other things, the MySql user to have remote access rights.

Jake Bunce

Wed 27th Mar '02, 9:23pm

thanks for the info guys