Restore backup error

3 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: July 10, 2014   (RSS)

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

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...

Cheers,

Tim (toledoh.com.au)