The batch file contains:

@echo off for /f %%i in ('wmic path win32_LocalTime get DayOfWeek') do set wd=%%i if %wd%==1 (F:\OpenServer\modules\database\MySQL-5.7\bin\mysqldump diplome --user=root > backup1.sql) if %wd%==2 (F:\OpenServer\modules\database\MySQL-5.7\bin\mysqldump diplome --user=root > backup2.sql) if %wd%==3 (F:\OpenServer\modules\database\MySQL-5.7\bin\mysqldump diplome --user=root > backup3.sql) if %wd%==4 (F:\OpenServer\modules\database\MySQL-5.7\bin\mysqldump diplome --user=root > backup4.sql) if %wd%==5 (F:\OpenServer\modules\database\MySQL-5.7\bin\mysqldump diplome --user=root > backup5.sql) if %wd%==6 (F:\OpenServer\modules\database\MySQL-5.7\bin\mysqldump diplome --user=root > backup6.sql) if %wd%==7 (F:\OpenServer\modules\database\MySQL-5.7\bin\mysqldump diplome --user=root > backup7.sql)

Ie every day of the week, he creates a different backup from Mysql

Mistake:

 Непредвиденное появление(F:\OpenServer\modules\database\MySQL-5.7\bin\mysqldump)
  • set% file%%%% i In (% file%) Set SETESTEST = %% ~ ti F: \ OpenServer \ modules \ database \ MySQL-5.7 \ bin \ mysqldump diplome --user = root> backup \% timestamp: ~ 0.10% .sql - Fedor

1 answer 1

Error due to %wd%==n need to escape "%wd%"=="n" . And in general, why the conditions?

 @echo off For /f %%# In ('WMIC Path Win32_LocalTime Get DayOfWeek^|Findstr [1-7]') Do (Set wd=%%#) F:\OpenServer\modules\database\MySQL-5.7\bin\mysqldump diplome --user=root > "backup%wd%.sql"
  • Thanks, I will test - Fedor