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

Cheers,

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.

Dave Edis - Senior Developer
interactivetools.com