php - mysqldump to backup database from linux to windows server -


I have a mysql server on a Linux box (192.168.1.20), whose database is "retail". I want to make backups in Windows Server (192.168.1.30) in an automated way.

What is the best way to do this to run the following code:

  mysqldump -h 192.168.1.20 -U Root-P Retail & gt; Any kind of help would be greatly appreciated.   

"text">

how to create a bat file About:

  / start / wait mysqldump -uUSERNAME -pPASSWORD -h192.168.1.20 Retail & gt; Path_to_dump_file / start / wait mysql -UUSERNAME -pPASSWORD -h192.168.1.30- "Drop database retail; Create database retail;" / Start / veet ISISUL -USSEMET-PPSSword-H1982.168.1.30 retail & lt; Path_to_dump_file   

should do this.

Comments