MySQL backup and Restoration

1. Backup bat. Get the current date as the file name, compress the data everywhere and delete the source file

 

Echo off & setlocal enabledelayedexpansion for/F "tokens = 1-3 delims =-:/" % A in ("% date % ") do (set Y = % A & Set M = % B & set D = % C & if "! M :~ 0, 1! "=" 0 "Set M =! M :~ 1! If "! D :~ 0, 1! "=" 0 "set D =! D :~ 1 !) Set/a D-= 1 & if! D! Leq 0 (Set/a m-= 1 & if! M! = 0 set/a Y-= 1, m = 12 set/a "t = ^! (M-2) "," r = (^! (Y % 4) & ^! ^! (Y % 100) | ^! (Y % 400) "," c = ^! M-4 | ^! M-6 | ^! M-9 | ^! (M-11) "," d = T * (28 + r) + C * 30 + (^! T & ^! C) * 31 "+ d) Set M = 0% M % & set D = 0% d % set mydate = % Y % m :~ -2% % d :~ -2% echo % mydate % set bak_file = my_dbbak _ "% mydate % ". SQL set LOG_FILE = my_dbbak.log echo "% mydate %" "% LOG_FILE % mysqldump -- default-character-set = utf8-h192.168.1.1-uroot-r-padmin -- triggers -- Single-transaction-B dbname> % bak_file % RAR a folder bak_file=.rar % bak_file % del % bak_file % echo "% mydate %" "% LOG_FILE % echo" "% LOG_FILE % 2. Import

Mysql-uroot-p111111 dbname <AA. SQL