Store data

[CocaColaBear]

HI all!

I'm looking for the best way to store data, with minimal impact. Does anyone have any ideas?

I use MySQL. And save all data when a player leaves the server. But if the server is turned off (crash or etc) online players lose their data. How to be? Update their data every n-seconds?

Sry for my English

[glowdemon1]

I don't know much about mySQL and stuff but I think it'd be best to back everything up every 30 minutes incase the server crashes or so. Doing this each second or each minute could cause some lag AFAIK.

[bandi94]

Well , in the first place a good scripted server , shouldn't crash. IF it dose in regular time , then there are script's problem. In every case , how "glowdemon1" sayd a 30 - 60 min , backup. But in a normal server 1-2 backup / day is fine bk the server shouldn't crash 5-6 time's / day. My server crash'd 1 time in one month ....