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 ?
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.
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