Database backups? HFB

[Genesis]

Hello I was wondering if and how I could run automated database backups. Maybe every hour or so? 

Thanks in advance.

[Genesis]

edit: running dayz chernarus epoch on HFB server host =]

[Prero]

use following command with scheduler. I use following command with NAS scheduler. So the database is saved automatically every time I want even though I turned off my computer.

 

"xxxx" should be your user number.

 

 

 

DB_IP="hive.hfbservers.com"

DB_ID="user-xxxx"

DB_PW=your password"

DB_NAME="user-xxxx"

DB_BACKUP_NAME="setname"

 

mysqldump --ignore-table=user-xxxx.v_deployable --ignore-table=user-xxxx.v_player --ignore-table=user-xxxx.v_vehicle -h hive.hfbservers.com -u${DB_ID} -p${DB_PW} ${DB_NAME}>/Backup/`date +%Y%m`/`date +%Y%m%d`/${DB_BACKUP_NAME}_`date +%Y%m%d_%H%M`.sql"

 

For example, if the user number is 1234

 

 

DB_IP="hive.hfbservers.com"

DB_ID="user-1234"

DB_PW=your password"

DB_NAME="user-1234"

DB_BACKUP_NAME="setname"

 

mysqldump --ignore-table=user-1234.v_deployable --ignore-table=user-1234.v_player --ignore-table=user-1234.v_vehicle -h hive.hfbservers.com -u${DB_ID} -p${DB_PW} ${DB_NAME}>/Backup/`date +%Y%m`/`date +%Y%m%d`/${DB_BACKUP_NAME}_`date +%Y%m%d_%H%M`.sql"

 

Keep in mind that you may have to change the command based on your system.

[Genesis]

I'm sorry, what is NAS Scheduler and how would I use it, I've looked around and can't find much about it.

[Prero]

The NAS scheduler is not part of dayz or arma2 things. It's Network Attached Storage.

 

Anyway, if you don't have one, just ignore what I said in the previous post regarding to the NAS. Just keep in mind that you need "mysqldump.exe" file (if you installed XAMPP, you have it), and you have to make window scheduler and a batch file to backup your db.

 

1. Check if you have mysqldump.exe (or if you have XAMPP in your computer)

2. make a batch file using the command in my previous posting

3. setup window scheduler to run the batch file when you want (I have no experience about the window scheduler. You may need to search about that)

 

I'm not sure if you catch what I wanted to say, but I hope you will figure it out.

Good luck!