The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Backup and Mysql dump

Discussion in 'General Discussion' started by phoenixweb, Sep 19, 2006.

  1. phoenixweb

    phoenixweb Well-Known Member

    Joined:
    Jun 3, 2004
    Messages:
    68
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    DataCenter Provider
    :eek: When the backup try to dump an account with a mysql of 1.8 giga of data it fails.
    It's a problem of RAM (or some other hardware's component), or it's just a very bad idea to dump 1.8 giga of data?

    The backup is automatic.... so i cannot select to don't dump the mysql.
     
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    Do you have enough room on the HD? You can also increase "The load average above the number of cpus at which logs file processing should be suspended (default 0):" in Tweak Settings.
     
  3. phoenixweb

    phoenixweb Well-Known Member

    Joined:
    Jun 3, 2004
    Messages:
    68
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    DataCenter Provider
    Dear Andy,

    I have FTP backup to another server, and that server have enought space, also the HD on my server is almost empty. It's not a problem of space but of course of cpus / rams.

    However i cannot understand the second hint that you give me, how can suspend log file processing can help to do not fail to dump the mysql of the account?
     
  4. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    You can ignore that. I was thinking of something else; sorry about that. if you have 1GB of RAM and no high load, you should be fine.
     
Loading...

Share This Page