cpanel backup script to overcome php limits?

postcd

• October 26, 2013 08:01

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?

• 

  cPanelMichael

  • October 28, 2013 03:39

  Hello :) I recommend backing up the database via the command line with the mysqldump utility. EX: mysqldump database_name > /path/to/database_name.sql
  Thank you.

  0
• 

  postcd

  • October 28, 2013 23:16

  Thx, here is the whole guide based on your command. on how to automate these backups and backup to external server: [url=http://internetlifeforum.com/programming-scripting/1063-linux-bash-script-backup-mysql-folder-keep-only-files-younger-x-days/]Linux bash script to backup mysql to the folder and keep only files younger X days fortunatelly my cpanel reseller provider activated SSH for me, so i can backup automatically )

  0

Please sign in to leave a comment.