MySQL dump to backup crashes my server

[Micah]

Hi! I have a rathena running from Centos OS, and I love to back up my server automatically and everyday, but I have a problem, since my database is huge around 1.5GB, my server often crash saying

"Segmentation fault"

"# of players cannot be saved"

and my players could duplicate their items whenever this happens.

Any suggestion how would I be able to backup my server with server crash?

Thank you very much!

[Cookie]

Well, a database that size is going to stall a bit. Hmmm, been awhile since I've worked with replication (application I developed for IRL work we used replication for multiple sites; basically master schema and a bunch of slaves). I'll test it out myself... I've got a large server, as well.

You can also think about doing incremental backups. Either way, I'm going to test myself.

Edited July 16, 2012 by Cookie