Jump to content
  • 0

MySQL dump to backup crashes my server

Micah

Asked by Micah,

 Share

Question

Micah Poring

Micah

Posted
  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  3
  • Reputation:   0
  • Joined:  07/15/12
  • Last Seen:  
Posted

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!

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Cookie Poring

Cookie

Posted
  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  213
  • Reputation:   109
  • Joined:  05/21/12
  • Last Seen:  
Posted (edited)

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to question listing
×
×
  • Create New...