Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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:
    670
    Likes Received:
    11
    Trophy Points:
    68
    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:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    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:
    670
    Likes Received:
    11
    Trophy Points:
    68
Loading...

Share This Page