Cameron Posted January 22, 2011 Share Posted January 22, 2011 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 Link to comment Share on other sites More sharing options...
CrimsonGT Posted January 23, 2011 Share Posted January 23, 2011 Thanks for the release Cameron Link to comment Share on other sites More sharing options...
Cameron Posted January 23, 2011 Author Share Posted January 23, 2011 No problem! Link to comment Share on other sites More sharing options...
dimitrifrom31 Posted January 23, 2011 Share Posted January 23, 2011 just a tip, instead of zipping the files (can be a long process) use robocopy to make mirrored backups Link to comment Share on other sites More sharing options...
Cameron Posted January 24, 2011 Author Share Posted January 24, 2011 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.