How to do database backups

[RAMBO]

Any information regarding this would be greatly appreciated, even if it is just a link to another page. If you have the time and knowledge to explain it I certainly won't complain. Thanks guys ;)

 

 

[MGT]

Navicat premium can schedule backups, we backup all our servers every 15 minutes, rolling back is done in 1 click.

[Revoplay]

@MGT: can you share your navicat event code with us?

 

EDIT:

 

@RAMBO: Its important that you have enabled the Scheudle on your SQL Server

[haku]

Maybe this will help ,  made it on a rush

 

 

-

-

-

-

-

-

 

 

How to start Scheduler: /// or just follow this link here :/  http://dayzepoch.com/wiki/index.php/Server_Installation_Instructions_Extended

-

-

In console execute:

SET GLOBAL event_scheduler = 1;

Create hourly events like cleanup dead characters in db / vehicles / update stock in traders.

 

CREATE EVENT updateStockDaily

ON SCHEDULE EVERY 1 DAY

COMMENT 'Updates out of stock vendors'

DO

UPDATE `traders_data` SET qty=10 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat';

CREATE EVENT removeDamagedVehicles

ON SCHEDULE EVERY 1 DAY

COMMENT 'Removes damaged vehicles'

DO

DELETE FROM `object_data` WHERE Damage = 1;

I personally use :

CREATE EVENT `DeleteDeadBodies` ON SCHEDULE EVERY 1 HOUR STARTS '2013-05-28 09:12:27' ON COMPLETION PRESERVE ENABLE DO DELETE FROM `Character_DATA` WHERE Alive = 0;
 
CREATE EVENT `DeleteDestroyedVehicles` ON SCHEDULE EVERY 1 HOUR STARTS '2013-07-23 02:51:53' ON COMPLETION PRESERVE ENABLE DO DELETE FROM `Object_DATA` WHERE Damage = 1;
 
CREATE EVENT `UpdateTradersStock` ON SCHEDULE EVERY 1 HOUR STARTS '2013-07-23 02:51:53' ON COMPLETION PRESERVE ENABLE DO UPDATE `Traders_DATA` SET qty=50 WHERE qty<10;

 

 

/ IF i forgot anything im sorry , tell me and i will correct it and if you need anymore help , ask , if i can , i will.

Edited September 21, 2013 by haku

[Snowmobil]

http://www.percona.com/software/percona-xtrabackup

[haku]

That's for linux.

[Snowmobil]

Yea my bad, i thought they'd have a windows version by now, but thats still in alpha...

http://www.percona.com/downloads/XtraBackup/XtraBackup-1.6/Windows-alpha/

[haku]

Mods, Any where i can make a topic for this tutorial and stick it maybe ?