Automated backup

[Cameron]

Hi, I wrote this .bat script to backup my game servers and mySQL databases to my secondary hard drive, Thought i would release it

It uses 7zip command line program.

 

Set FileDate=%date:/=%
7za a -tzip "D:\Backup Files\UserFilesBackup\GameBackup_%FileDate%.zip" "C:\UserFiles\*"

echo Running dump... 
"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump" -u(username) -p(password) --all-databases --result-file="D:\Backup Files\MySQL Backup\backup.sql"
echo Done!

 

I made it backup all of the GameServers and mySQL databases as I provide free mySQL databases for customers.

Here is a link to a package that includes the .bat and the 7z exe

 

http://cameron.bz/mirrors/Backup.zip

 

I just set it as an automated task to run at 12:00 every night

 

I don't know if you will find it useful, but I thought I would release anyway!

 

Thanks for looking

[CrimsonGT]

Thanks for the release Cameron

[Cameron]

No problem!

[dimitrifrom31]

just a tip, instead of zipping the files (can be a long process) use robocopy to make mirrored backups

[Cameron]

just a tip, instead of zipping the files (can be a long process) use robocopy to make mirrored backups

 

Yeh, I did that before. I decided to compress it all into a .zip is so that I can keep a good archive for a few months, and keep down on the disk usage