Can anyone tell me what is the easy way to backup 500Gb datasize on windows environment ? My physical memory is 672 GB RAM on server? Which tools will be fast to back up and restore? Note : mysqldump will take more than 1 week for 500GB datasize Any suggestion with details and is there way any way around that it can take within 2 days?
You may give it a try using percona backup alpha version for Windows - Download_Link .
Below are the steps after installation in Windows Bash.
C:\Users\lorainne>bash C:\Users\lorainne$ xtrabackup –user=root –password=secret -host=127.0.0.1 –port=3306 –backup –target-dir=\test
I haven't tested this but this seems to be a working command, ensure that you have https://msdn.microsoft.com/en-us/commandline/wsl/release_notes - Build 14332 fixed to have prctl system call supported on Windows.