.bat files the will Backup MySQL and any important Arma 3 server files. These .bat files can be uses for multiple applications. 

Feel free to download and amend the files here: Link

If you want to automate the Arma 3 server backup, insure you remove the “pause” from around line 96.

Avoid spaces in your file patch, this has been known to break the script.

If you would like help visit: http://darkmattergaming.com

Useful tools:
Notepad++: https://notepad-plus-plus.org/download/v6.9.html 
CMTools (for log files): https://www.microsoft.com/en-us/download/details.aspx?id=50012
7zip: http://7-zip.org/download.html
Visual Studio Code: https://code.visualstudio.com/Download

Grab it here: https://sourceforge.net/projects/mysqldumper or here https://github.com/aussie-battler/MySql-Dumper

About: MySQLDumper is a free web based backup/restore script for MYSQL which can handle huge dbs. You can use cpanel's cron jobs to create regular backups of multiple databases to FTP sites. Unfortunately there is no longer any support, however install / setup is easy.

Installation is very easy: Upload the install files to your website. Configure the databases & ftp site to backup to.

Here is a tutorial: https://www.1and1.com/digitalguide/hosting/technical-matters/creating-backups-with-mysqldumper/

Schedule backups: 

1. in MySQLDumper click in the "backup" tab.

2. Click "Backup Perl"

3. Copy the "Commandline in the Shell or for the Crontab" (your path to MysqlDumper will be different):
 

4. Open Cpanel on your website.

5. Click "cron Jobs".
6. Schedule how often you would like to backup & if you want to receive an email notification.

7. Paste in the MysqlDumper command into the "command section".

Sit back & crack a beer.

I created this so people could be made aware of Shadow Copy Service in Windows. 

Thanks, 

Josh

Here is one i use, that does very well. V1.0

It Xcopies C:\Arma stored server (directory) all files *.* then copies the files to your backup Location

it passes arguments /e/h/k/y/z

/e : Copies all subdirectories, even if they are empty. Use /e with the /s and /t command-line options.

/h : Copies files with hidden and system file attributes. By default, xcopy does not copy hidden or system files.

/k : Copies files and retains the read-only attribute on destination files if present on the source files. By default, xcopy removes the read-only attribute.

/y : Suppresses prompting to confirm that you want to overwrite an existing destination file.

/z : Copies over a network in restartable mode.

For more arguments visit:

http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/xcopy.mspx?mfr=true

Or google it for other great sites.

Windows based.

ECHO OFF
CLS
color b1
ECHO.
ECHO ...............................................
ECHO ...............................................
ECHO .........SCHEDULED TASK BACKUP.................
ECHO ...............................................
ECHO ...............................................
XCOPY "c:\Arma3Servers\Server3\*.*" C:\Arma3Servers\Backup\Server3\ /e/h/k/Y/z

Change your settings to your own Server Directory, and Backup Drive file locations.

Create a task Scheduler, and link it to this bat file which can be stored in your server root folder.

http://windows.microsoft.com/en-US/windows/schedule-task#1TC=windows-7

You can modify this,  and backups with no flaws i have noticed yet.

** Working on adding in the Mysql Simple backup included in this.**

Sneaks

Thanks in advance for helping a newbie! 

I thought I would share an SQL Backup .bat file, make sure you run this with Task Scheduler and change the directories to your preferences.

SET backupTime="%date:~0,2%-%date:~3,2%-%date:~6,6%_%time:~0,2%-%time:~3,2%"

mysqldump --user=root --password=[password] exile > E:\Backup\SQL\%backupTime%.sql

 

First let's create the backup script.

dbbackup.sh

#!/bin/sh
#----------------------------------------------------
# Change DATABASE, USER, and PASS to match your
# mysql parameters.
# DBSERVER can be changed IF you have enabled remote
# access to your MySQL server.
# Change DEST to where you would like to store backups.
# No trailing /
#----------------------------------------------------
DEST=/home/unbound/A3Exile/dbbackup
FILE=$DEST/exile.`date +"%Y_%m_%d_%H%M"`.sql
DBSERVER=127.0.0.1
DATABASE=exile
USER=exile
PASS=password12345

mysqldump --opt --user=${USER} --password=${PASS} ${DATABASE} > ${FILE}

gzip $FILE

Now we create the cleanup script.

dbcleanup.sh

#!/bin/bash
#----------------------------------------------------
# Database Cleanup Script
# Change DEST to your backup directory, no trailing /
# Change +30 to the age in days to delete. (+7 = 7 days +30 = 30 Days)
#----------------------------------------------------
DEST=/home/unbound/A3Exile/dbbackup
find $DEST/* -mtime +7 -exec rm {} \;

Use the "crontab -e" command to schedule these scripts. You can use this to help with your schedule.

I add this to the end of my cron to schedule backups every 30 minutes and cleanup once a week. (4am sundays)

You will want to change the locations of your scripts accordingly.

#Exile Database Backup
*/30 * * * * /home/unbound/scripts/dbbackup.sh

#Exile Backup Cleanup
0 4 * * 0 /home/unbound/scripts/dbcleanup.sh