backups

[Bruiser 12]

What are you peeps using for backups? I'm hosting mine on windows environment. any thoughts?

 

[Flowrider85 10]

Navicat Pro works fine.

[Cael817 34]

I use MySQLBackupFTP (Free version) taking hourly backups which seem to do the job.

[Oreo 23]

Navicat Pro ( crack ) ez ( Automatic Save any 4h directly on the pc )

Edited September 10, 2015 by Oreo

[Defent 244]

I got a bat script that does it for me, it's launched through BEC at the moment however you can also set it to be run through FireDaemon or general windows services. It looks like this:

@echo off
FOR /F "tokens=1-4 DELIMS=/ " %%F IN ('date /T') DO (set v_date=%%F%%G%%H) 
FOR /F "tokens=1-4 DELIMS=: " %%F IN ('time /T') DO (set v_time=%%F%%G%%H) 
set fname=database_backup_%v_date%_%v_time%.sql 
echo %v_time% 
echo %fname% 
cd /D "C:\MySQL Server 5.6\bin"
mysqldump -u MYUSERNAME -p DATABASENAME1 --password=MYPASSWORD --result-file="C:\Backups\A2Chernarus\%fname%"
mysqldump -u MYUSERNAME -p DATABASENAME2 --password=MYPASSWORD --result-file="C:\Backups\A3Exile\%fname%"
mysqldump -u MYUSERNAME -p DATABASENAME3 --password=MYPASSWORD --result-file="C:\Backups\A2Panthera\%fname%"
ping 127.0.0.1 -n 5 >NUL
exit

 

[WD-40 25]

If someone needs script for linux just create file named backup including:

mysqldump --opt -uUSER -pPASSWORD exile > $(date +%F_%R).sql
mysql -u USER -pPASSWORD -e 'DELETE FROM player WHERE is_alive = 0 OR account_uid = "SomethingWentWrong" OR account_uid = ""' exile
mysql -u USER -pPASSWORD -e 'DELETE FROM vehicle WHERE damage = 1;' exile
mysql -u USER -pPASSWORD -e 'DELETE FROM container WHERE last_accessed < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 30 DAY);' exile

It will create the db backup, after that it will remove olf player records, wrecks and old containers

To run it on every server restart i use cron (crontab -e command):

0 0,3,6,9,12,15,18,21 * * * cd /home/user/exile/ && ./starter restart #server restart 
0 0,3,6,9,12,15,18,21 * * * cd /home/user/baza/ && ./backup #execution of backup script
* * 1 * * find /home/user/baza/*.sql -mtime +7 -exec rm {} \; #remove 7+days old backups (every 24 hrs)

I also use few php scripts through cron to announce restarts.

Edited September 10, 2015 by WD-40

[CEN 449]

I've used this for years: http://www.redolive.com/utah-web-designers-blog/automated-mysql-backup-for-windows/

[itsatrap 251]

I've used this for years: http://www.redolive.com/utah-web-designers-blog/automated-mysql-backup-for-windows/

yeah this script rocks, i backup every 30 min, 

[galgenjunge 0]

We use http://www.mysqldumper.de/ on Linux..