Found great SQl backup script but have problems

[maxx]

http://www.dagondesign.com/articles/...backup-script/

It worked for a while but then when I run it I get an error:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 56328192 bytes) in /XXX/XXX/XXXX/backups_dbs.php on line 303


I tried to raise memory size at /root/ispconfig/php.ini to 50M
also tried to raise Mysql my.cnf max_allowed_packet
But the allowed memory size doesn't increase.

Anyone? Where should I increase the values? What is the right place?

- Maxx

[falko]

Which distribution? How do you run the script?

[maxx]

I running ISPconfig 2 and also installed another sql backup program (phpmybackuppro v 2.1) but that also doesn't sent me backups by email.

I run the script from cron.

[falko]

Originally Posted by maxx

I run the script from cron.

What's the exact command?

Which Linux distribution do you use?

[maxx]

I'm using Ubuntu 9.04 and Cron command is
30 0 * * * php /home/XXX/backups/backup_dbs.php

I dont think it's about the command because phpmybackuppro has also problems sending backups to me via email.

[maxx]

Solved, it was because of the SMTP mail size limit.

So I did:

postconf -e 'message_size_limit = 104857600
And restart postfix /etc/init.d/postfix restart
After that to verify that is the new global value:

postconf -n | grep message_size_limit
(Found this stuff from your forums)

Everything else like PHP limits were right.

Thanks for your help.

- Joakim