ihipop ihipop

sindresorhus / mysql-backup-windows.bat

Created March 14, 2011 14:50

Backup MySQL databases in separate gzipped sql files on Windows

	@echo off

	set dbUser=root
	set dbPassword=password
	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"

	:: get date