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.
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.
Sorry Rony, I didn't see your message when I started writing mine!
Not an issue.
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.
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.
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/...
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/...
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.
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
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
Rony