4-2) Got a backup by mysqldump.exe in the corresponding directory & file name.4-1) Prepared a file name based on current date.
SQL BACKUP SCHEDULE WINDOWS
but with little difference and extra work:Ģ) Ran that batch file through windows schedulerģ) Made appropriate schedule for that taskĤ) Inside the batch file these steps are executed: I did the work, similar to what other people explained through.
add it to a new task Action and set a trigger (Windows Task Scheduler).use the -result-file option instead of > According to the Mysql Manuel, the charset of file saved using ">" is UTF-16, while the -result-file follows the -default-character-set.substr the variable through %variable:~startpos,length%.Note that the 2 variables are based on locale and cmd shell version To create file whose name is based on the date and time, use %date% and %time%. Rem Backup Database (Daily,via Task Scheduler)
0 kommentar(er)
