Shulou(Shulou.com)06/02 Report--

@ echo off

Rem deletes the database backup 7 days ago

Cd D:\ db_bak\ qd_web_project\ dump

Forfiles / m * .sql.gz / d-7 / c "cmd / c del @ file / f"

Cd D:\ db_bak\ ios_web_project\ dump

Forfiles / m * .sql.gz / d-7 / c "cmd / c del @ file / f"

Cd D:\ db_bak\ game_db_all\ all

Forfiles / m * .sql.gz / d-7 / c "cmd / c del @ file / f"

Cd D:\ db_bak\ game_db_all\ dump

Forfiles / m * .sql.gz / d-7 / c "cmd / c del @ file / f"

Cd D:\ db_bak\ android_web_project\ dump

Forfiles / m * .sql.gz / d-7 / c "cmd / c del @ file / f"

Rem generates backup database

Cd / DC:\ Program Files\ MySQL\ MySQL Server 5.6\ bin

SET filePath=D:\ databackup\ db\% date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%

SET sqlPath=%filePath%.sql

SET rarPath=%filePath%.rar

Mysqldump.exe dbname-P 3306-uroot-proot >% sqlPath%

Rem compressed backup database files

"D:\ Program Files (x86)\ WinRAR\ WinRAR.exe" a-ibck-m5% rarPath%% sqlPath%

Rem delete data and add files

Del sqlPath%

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.