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.

cpanel backup script to overcome php limits?

Discussion in 'Data Protection' started by postcd, Oct 26, 2013.

  1. postcd

    postcd Well-Known Member

    Joined:
    Oct 22, 2010
    Messages:
    622
    Likes Received:
    6
    Trophy Points:
    18
    Hello,

    which way can i backup 70mb big mysql cpanel database so i dont reach my PHP limits (execution time, max memory etc..)?
    It appears my automatic php backup script no longer works because mysql is too big. Any AUTOMATED mysl backup script which can backup in batches or with delays so limits are not reached?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    I recommend backing up the database via the command line with the mysqldump utility. EX:

    Code:
    mysqldump database_name > /path/to/database_name.sql
    Thank you.
     
  3. postcd

    postcd Well-Known Member

    Joined:
    Oct 22, 2010
    Messages:
    622
    Likes Received:
    6
    Trophy Points:
    18
Loading...

Share This Page