mysql_自动备份

      
         1
      
      
        @echo off


      
      
         2
      
      
        set
      
       errorlevel=
      
        0
      
      
         3
      
      
        set
      
       dump_command=
      
        "
      
      
        C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump
      
      
        "
      
      
         4
      
      
        set
      
       db_name=
      
        test_db 


      
      
         5
      
      
        set
      
       backup_dir=
      
        D:\back\


      
      
         6
      
      
        set
      
       timestamp=%date:~,
      
        4
      
      %%date:~
      
        5
      
      ,
      
        2
      
      %%date:~
      
        8
      
      ,
      
        2
      
      %


      
         7
      
      
        set
      
       backup_jira_file=
      
        "
      
      
        %backup_dir%%db_name%_backup_%timestamp%.sql
      
      
        "
      
      
         8
      
      
        set
      
       user_mysql=
      
        root 


      
      
         9
      
      
        set
      
       password_mysql=
      
        root


      
      
        10
      
       echo backup mysql database:%db_name% 


      
        11
      
       %dump_command% --no-defaults -u%user_mysql% -p%password_mysql% %db_name% > %backup_jira_file%


      
        12
      
      
        echo end backup


      
      
        13
      
       pause;