Restore backup error
3 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: July 10, 2014 (RSS)
By Toledoh - July 8, 2014
Hi Guys,
I'm trying to restore a backup and getting the following error, any thoughts?
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 101724989 bytes) in /home/XXX/public_html/cmsAdmin/lib/database_functions.php on line 787
Tim (toledoh.com.au)
By Dave - July 10, 2014
Hi Tim,
CMS Builder's built in backup and restore is limited by server resources, so you will reach a point when it's no longer possible through the web interface. I was recently working on a 13 gigabyte MySQL database and as the size increase you need to use different approaches for backup and restore.
That said, here's some options for right now:
- Try splitting the backup file into two or more files backup-1of2.sql.php and backup-2of2.sql.php and restoring them one after another.
- Otherwise, you can try another web tool such as phpMyAdmin to backup and restore which might work with larger databases
- Finally, it's possible to do from the command line with mysql tools. Google for: mysql backup and restore
Hope that helps! Let me know how it goes.
interactivetools.com
By Toledoh - July 10, 2014
Thanks Dave.
I ended up going into the original site and seeing why the backup was so large. It turns out the outgoing email log and the background task log summary were huge. I deleted those and took the backup file down from 50Mg to under 1 Mg...
Tim (toledoh.com.au)