Backup MySQL databases on windows (.bat file)

[dotnetic]

Hey guys I wanted to share this little snippet with you, which can be run as a .bat file, and backups all of your databases into a separate file:

K:\laragon\bin\mysql\mysql-5.7.19-winx64\bin\mysql.exe -uroot -s -N -e "SHOW DATABASES" | for /F "usebackq" %%D in (`findstr /V "information_schema performance_schema"`) do K:\laragon\bin\mysql\mysql-5.7.19-winx64\bin\mysqldump.exe %%D -uroot > P:\htdocs\database-backups\%%D.sql

of course you have to change the paths to your mysql/mysqldump.exe files and the destination directory, and the username, if you have to provide another than root.

This task can be executed daily via task scheduling in Windows.

[dragan]

Thanks for sharing. ?