Found great SQl backup script but have problems

Discussion in 'General' started by maxx, Jul 24, 2010.

  1. maxx

    maxx ISPConfig Developer ISPConfig Developer

    http://www.dagondesign.com/articles/automatic-mysql-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
     
  2. falko

    falko Super Moderator ISPConfig Developer

    Which distribution? How do you run the script?
     
  3. maxx

    maxx ISPConfig Developer ISPConfig Developer

    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.
     
  4. falko

    falko Super Moderator ISPConfig Developer

    What's the exact command?

    Which Linux distribution do you use?
     
  5. maxx

    maxx ISPConfig Developer ISPConfig Developer

    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.
     
  6. maxx

    maxx ISPConfig Developer ISPConfig Developer

    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
     

Share This Page