Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 24th July 2010, 20:50
maxx maxx is offline
Member
 
Join Date: Jul 2005
Location: Finland
Posts: 70
Thanks: 2
Thanked 0 Times in 0 Posts
Send a message via MSN to maxx Send a message via Skype™ to maxx
Default Found great SQl backup script but have problems

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
Reply With Quote
Sponsored Links
  #2  
Old 25th July 2010, 13:57
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

Which distribution? How do you run the script?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 26th July 2010, 13:35
maxx maxx is offline
Member
 
Join Date: Jul 2005
Location: Finland
Posts: 70
Thanks: 2
Thanked 0 Times in 0 Posts
Send a message via MSN to maxx Send a message via Skype™ to maxx
Default

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.
Reply With Quote
  #4  
Old 27th July 2010, 14:53
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

Quote:
Originally Posted by maxx View Post
I run the script from cron.
What's the exact command?

Which Linux distribution do you use?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
maxx (28th July 2010)
  #5  
Old 27th July 2010, 23:47
maxx maxx is offline
Member
 
Join Date: Jul 2005
Location: Finland
Posts: 70
Thanks: 2
Thanked 0 Times in 0 Posts
Send a message via MSN to maxx Send a message via Skype™ to maxx
Default

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.
Reply With Quote
  #6  
Old 28th July 2010, 00:00
maxx maxx is offline
Member
 
Join Date: Jul 2005
Location: Finland
Posts: 70
Thanks: 2
Thanked 0 Times in 0 Posts
Send a message via MSN to maxx Send a message via Skype™ to maxx
 
Default

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig 3 - back-res a Backup and Restore script go0ogl3 Plugins/Modules/Addons 217 23rd July 2014 15:23
Online Backup : What do you use and how do you setup it ? XZed Technical 5 4th January 2010 18:02
Setting up a new server - Suse 11.1 londonman Server Operation 34 10th April 2009 13:16
Cannot log onto pop3 server Debian Etch Perfect Server docean Installation/Configuration 2 19th March 2008 00:23
apt-get failure yap HOWTO-Related Questions 1 19th November 2006 22:33


All times are GMT +2. The time now is 20:27.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.