Skip to content

Instantly share code, notes, and snippets.

@LQ80

LQ80/backup_mysql_databases.bat

Created May 1, 2021 21:39
Show Gist options
  • Save LQ80/f70d30779c817d0dc65f871dc14556d5 to your computer and use it in GitHub Desktop.
Save LQ80/f70d30779c817d0dc65f871dc14556d5 to your computer and use it in GitHub Desktop.
Download ZIP
Backup MySQL Databases Batch File
Raw
backup_mysql_databases.bat
@echo off
SET DIR="c:\wamp64\bin\mysql\mysql5.7.28\data\*"
FOR /D %%i IN (%DIR%) DO (
c:\wamp64\bin\mysql\mysql5.7.28\bin\mysqldump.exe -u root %%~nxi > DB\%%~nxi.sql
ECHO %%~nxi.sql
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment