I an having Remote Windows Server having Xampp installed. And now i want to take backup of Mysql DB every night through scheduled task and to save that backup on my local machine from which i have triggered the scheduled task. For this, i have created a php script which takes Mysql DB Backup. Also i have created a scheduler that runs the batch file from which i called that php script but the DB Backup file created i been saved on Server only.. I have to save it on my local machine...? Please help to solve this problem..? Thanks in advance..
If you're calling a batch file to execute a PHP file, you could also do the backup directly from that batch file by using mysqldump.exe which is provided by MySQL itself. A possible syntax would be: "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe" -u%user% -p%pwd% %yourdatabase% > Y:\ourbackuppath\filename.sql
I hope this is helpful for your purpose.