Jump to content
  • 0

How to do database backups


RAMBO

Question

7 answers to this question

Recommended Posts

  • 0

Maybe this will help ,  made it on a rush

 

07_zpsa79db428.png

 

-

1_zpsb60124f2.png

-

2_zps20b36aca.png

-

3_zps13a8a4f4.png

-

4_zpse7f0c983.png

-

5_zpscb50dc92.png

-

6_zps6f46fc57.png

 

 

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

6_zps6f46fc57.png

-

scheduler2_zps5021e35f.png

-

In console execute:

SET GLOBAL event_scheduler = 1;

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

 

query_zps9ffc7933.png

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 by haku
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Advertisement
  • Discord

×
×
  • Create New...