Database back up error.... please help

Permalink
Every time I try to backup my database so that I can run an update, I get the following error:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 9600867 bytes) in /home6/hillbil6/public_html/concrete/libraries/backup.php on line 19

I have tried downloading previous, current and newer versions of concrete5 to my computer, copying the backup file and placing it in my directory with no success. Please tell me how to fix this.

 
ronyDdeveloper replied on at Permalink Reply
ronyDdeveloper
The error is not related to Concrete5 rather it is related to your hosting provider. It just doesn't allowed the memory size required by Concrete5 to execute the backup program. Just ask your server administrator to increase the memory limit. It will solve this issue. Also you can directly export the database from Cpanel. If you are not aware, just ask your server admin to help.

Rony
mesuva replied on at Permalink Reply
mesuva
Sorry Rony, I didn't see your message when I started writing mine!
ronyDdeveloper replied on at Permalink Reply
ronyDdeveloper
Not an issue.
mesuva replied on at Permalink Reply
mesuva
The backup operation in the dashboard is fairly memory intensive, so it's simply using too much memory than what your webserver is set to allocate to a web request. It's not really a bug as such, it's just that this can happen when databases get a bit bigger or your running on a system with not overly huge resource limits.

Although you could look to change your server's memory limits, and that might work, a better solution is to simply not use the backup mechanism in the dashboard and to do a backup more directly.

If it's on a server with something like cPanel, you can log in there and use the 'Backups' section and download a database backup from there. You can also use phpMyAdmin to via your database and trigger a backup there as well (although it's pretty much the same thing).

If you are hosting your site on your own machine, you may be able to use phpMyAdmin, or another database tool.

The only difference is that the database backup file you create will be download and stored on your computer, whereas the concrete5 dashboard method stores it for later reference.

I suggest this way as these methods aren't subject to limitations of memory and are very reliable, but it's also good to know how to backup and restore database _outside_ of concrete5. Knowing how to directly export and import a database 'dump' is a a handy thing to know when you're using any CMS to be honest.
JohntheFish replied on at Permalink Reply
JohntheFish
This may help

http://www.concrete5.org/documentation/how-tos/developers/backup-a-...

For many sites, the worst offending table is the page statistics, so while in phpMyAdmin you could truncate that table (truncate **NOT** delete), and that may enable the built in database backup to complete.

If your current c5 version supports it, Extreme Clean will truncate the Page Statistics and remove all but the current page versions of all pages.

http://www.concrete5.org/marketplace/addons/extreme-clean/...

Finally, for a solution that can backup both database and files without having to go through any of the above, have a look at Backup Voodoo.

http://www.concrete5.org/marketplace/addons/backup-voodoo/...
dreampro replied on at Permalink Reply
Problem solved... I went into the php.ini file and changed the memory limit from 32B to 64B. Now it backs up just fine. Thanks for all the help.
niwes replied on at Permalink Reply
niwes
Hello ,
I know the thread is older ...

but I just do not get out
re-establish the normal access!

cann someone help me
my websitehttp://www.primewriter.de

PS: i have NO access to the Main site or to the Dashboard