Jorge Pacheco pachecoder

Software Developer.

pachecoder / mysql-backup-windows.bat

Last active September 19, 2015 11:20 — forked from sindresorhus/mysql-backup-windows.bat

Backup MySQL databases in separate gzipped sql files on Windows

	@echo off

	set dbUser=root
	set dbPassword=yourPassword
	set backupDir="C:\Documents and Settings\user\Desktop\backup\mysql"
	set mysqldump="C:\Program Files\MySQL\MySQL Workbench 5.2 CE\mysqldump.exe"
	set mysqlDataDir="C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data"
	set zip="C:\Program Files\7-Zip\7z.exe"

	::Change date delimiter to -