Windows serverserver end MySQL own active database backup

1. Give root all authorized accounts SQL talent

Grant all privileges on * * to [e-mail protected] "%" identified by ".";

Flush privileges;

2. Create a bat batch file

@echo offset path=%path%;D: \program Files\mysql\mysql Server 5.5\binset Y=%date:~0,4%set m=%date:~5,2%set d=%date:~8,2 %set h=%time:~0,2%set cdate=%y%%m%%d%_%h%mysqldump-h 127.0.0.1-u root--password=*****-e-r--database cmsis > F:\da Ta\cmsis_%cdate%.sqlexit

Where Cmsis is the database to be backed up, files such as Cmsis_20140510_16.sql are generated under F:\data when the batch file is run

3. Join the Scheduled Tasks

(1) Join the task plan, System tools, accessories, programs, and more

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvaglsmjawma==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/southeast ">

(2) Click Next

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvaglsmjawma==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/southeast ">

Click Browse to select the bat file you just created

(3) Set task run time

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvaglsmjawma==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/southeast ">
Then click Next and enter admin password to be able!

Copyright notice: This article Bo Master original articles, blogs, without consent may not be reproduced.

Windows serverserver end MySQL own active database backup