[Vtigercrm-developers] Backup runs out of memory

[Adam Heinz]

On Mon, Sep 10, 2012 at 5:02 AM,  <mail at dvoges.de> wrote:
> Hello Agaain,
>
> am I alone? Do you have nothing to backup or do you have a solution to
> backup larger Systems?
>
> Thank, Detlef

We don't use the vTiger backup script, just some cron jobs that look like

mysqldump --skip-lock-tables --single-transaction $dbname | gzip >
$backdir/daily/$appfqdn.`date +%F`.sql.gz"

cat $backdir/filelist | xargs tar cz -C /var/www/$appfqdn >
$backdir/daily/$appfqdn.`date +%F`.site.tgz"

(Sorry if these examples don't run, I hacked some identifying
information out of them)

Yes, attachments are a problem.  I periodically get a disk IO chirp
from Nagios in the middle of the night because it hammers the disk for
a long time zipping all the attachments.  At some point in the future,
I think we're going to have to move away from zip file attachment
backups.