phpstudy 自动备份

@echo off

set yyyy=%date:~,4%
set mm=%date:~5,2%
set dd=%date:~8,2%
if /i %time:~0,2% lss 10 set hh=0%time:~1,1%
if /i %time:~0,2% geq 10 set hh=%time:~0,2%
set mn=%time:~3,2%
set ss=%time:~6,2%
set date=%yyyy%%mm%%dd%
set time=%hh%%mn%%ss%
set filename=%date%_%time%


"C:\phpstudy_pro\Extensions\MySQL5.7.26\bin\mysqldump">mysqldump --opt -P3306 -u root --password=123456 --databases apiadmin --tables qqb_ywsld qqb_ywcld qqb_wtqzm qqb_dwarea qqb_user --single-transaction >C:/DatabaseBackUp/databasename_%filename%.sql

@echo on
#@paus