I have to create a backup plan, from my machine .155 to .156.

In .155 my files are in C:/MySQLServer/backup and should be copied daily to .156 at I:/MySQLServer/backup, so I was looking over the internet for some tool like rsync in Linux. But I also was thinking into Map network drive that has in both Windows Server v6.

So I'm wondering about the differences, the advantages and disadvantages between both. Any suggestions or ideas ?

  • I'm not sure what you think mapping a drive will do for you, you would still need something like rsync/xcopy/robocopy/etc to copy the data from one location to the other. – Rex May 22 '13 at 18:06
  • But if I map the drive, should do the same thing basically ? Adding the remote drive into my .155 server ? – Valter Silva May 22 '13 at 18:07
  • yes - but it won't copy any data. Rsync is an application that will copy/mirror data. It won't "add" the remote drive. Think of mapping the drive like mounting a filesystem except the drive letter is the mount point. – Rex May 22 '13 at 18:09
  • Got it. You would only 'read' the files, not write into the remote drive right ? – Valter Silva May 22 '13 at 18:13
  • No. you can write to the drive after you mount it (provided you have permissions). My point is just mapping a drive doesn't do anythign for you. You would still need to use a script/backup utility, batch file, rsync, application, or SOMETHING to copy the data from your .155 server to the mapped drive. – Rex May 22 '13 at 18:15

Why not use rsync/Cygwin for windows? Deltacopy has a package that will push both together.

There are other options you can do depending on if/what you have budget for and what problem you are actually trying to solve (ie: do you just want your backups off the server? Why not have MySQL backup directly to the remote server? do you need multiple copies of the backup? Is using an actual backup application feasible? etc)

edit: If you are looking at Cobian backup, why are you mentioning rsync? Those would do the same things.

If all you want to do is copy data from one location to another and there isn't that much data, write a batch/powershell/vbscript to do the file copy using UNC paths and run it as a scheduled task. Just make sure the user account that it is set to run under has proper permissions to the local directory and the remote share. If you want logging, you can do that with robocopy or redirect the output of your file copy to a text file in your script. If you want to use a 3rd party tool like Cobian, you can run it as a service and still use UNC paths to the appropriate servers.

  • I don't want to MySQL do the backup job, 'cause is faster do it locally and the schedule some application as you suggest to do that. – Valter Silva May 22 '13 at 18:15
  • Hmm, I didn't know that Cobian Backup can be used to copied the files remotely, great to know that, thank you! It's perfect 'cause I can schedule on it and run in service level. – Valter Silva May 22 '13 at 18:25
  • 1
    It says so right on the page: "Cobian Backup is a multi-threaded program that can be used to schedule and backup your files and directories from their original location to other directories/drives in the same computer or other computer in your network." – Rex May 22 '13 at 18:27

Microsoft cloned rsync in a tool named robocopy and it supports permissions cloning and windows shares. please note that the command line is very different, check some examples

that said, i usually do a net use j: //server/share and do the rsync using it. usually i only want the data, but if needed, there is a small free tool that can copy the permissions

  • 1
    I think that it's a disservice to call robocopy a clone of rsync. Sure, they're both powerful file copy tools, but that's really where the similarities end. – MDMarra May 23 '13 at 14:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.