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.

Large database backups

Discussion in 'Data Protection' started by cyc, Jul 9, 2010.

  1. cyc

    cyc Member

    Joined:
    Feb 18, 2004
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    I'm currently having a strange issue with cpanel backups where the sql dump of a large database seems to never exceed about 2.2GB, the database is approx 15GB. The entire mysql directory is copied fine, no problems with this part of the backup.

    Backups using mysqlhotcopy also work fine.

    Is this a common problem?
     
    #1 cyc, Jul 9, 2010
    Last edited: Jul 10, 2010
  2. cyc

    cyc Member

    Joined:
    Feb 18, 2004
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    anyone? :confused:
     
  3. syslint

    syslint Well-Known Member

    Joined:
    Oct 9, 2006
    Messages:
    249
    Likes Received:
    6
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    You may need to edit /etc/my.cnf as follows, and restart mysql server.

    -------
    [mysqldump]
    quick
    max_allowed_packet = 16M
    [mysqlhotcopy]
    interactive-timeout
    ----------
    And try to take cpanel backup now
     
Loading...

Share This Page