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
Post a Comment