cpanel backup script to overcome php limits?

[postcd]

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]

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.

 

[postcd]

Thx, here is the whole guide based on your command. on how to automate these backups and backup to external server: 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 )