How to run SQL code (preventing base structures from being deleted)

[Joe]

Hi guys,

I've seen lots of places where people have posted the below:

 

"Prevent Cleanup of base building items

This is NOT recommended and is a only a workaround to prevent base building items from being cleaned up by the normal internal cleanup system. PLEASE NOTE: This will cause issues due to keeping too many objects in the world.

CREATE EVENT preventCleanup
    ON SCHEDULE EVERY 1 DAY
    COMMENT 'prevents all cleanup by setting datestamp to current'
    DO
        UPDATE `object_data` SET `Datestamp`=CURRENT_TIMESTAMP WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )"

But I can never seem to find a post that explains how to do this, could someone please help me by telling me how to run this.

Any help would be great.

 

 

 

Regards

Joe

[haku]

http://dayzepoch.com/forum/index.php?/topic/1700-how-to-do-database-backups/?p=11523

 

It explains here how to enable the Events to run hourly or whatever.

[Joe]

Does this work with Xstreamgaming.net?

and how do I configure navicat with my Database/Server?

 

Regards

Joe