Automatically backup MySQL database with Batch file on Windows
Data backup is always very important in the way each system operates. In Linux you can easily automatically install the Crontab command, so what about Windows? We need to write code in Batch file and setup Task Schedule in Windows operating system. Very simple and fast. Task Schedule is available in Windows operating system. You need to turn it on and map it to a Batch file. Our problem is running on Windows, maybe Windows 7, 10, Windows server and backing up data from MySQL. The need to prepare: 1. Assuming we are using Xampp, you need to find the path of the mysqldump file 2. Prepare information about database: User, Password, Database Name 3. Prepare a database storage path. Database in this article will be saved as folder name of database, which will contain file mysql with format Year-month-date.sql Doing: 1. Open the task schedule by either search command or in the Control panel. 2. Create Basic Task 3. Type name of task 4. Select auto-run time: daily, weekly, monthly, … 5. By d...