Backup Execution Fatal Error

2 posts by 2 authors in: Forums > CMS Builder
Last Post: August 13, 2012 (RSS)

Archived
Reply
Reply

By sidcam - August 10, 2012

When I manually attempt a Database Backup I'm getting the following error:

Fatal error: Maximum execution time of 30 seconds exceeded in /xxx/xxx/xxx/xxx/lib/database_functions.php on line 705

I'm assuming that means my database is too big and I need to edit "database_functions.php" to give it more time. Correct? Any suggestions for how much time I should allow?

Also, I just purchased The Auto Backup plugin today. Is there anything there that needs editing as well?

Thanks, Sid

Re: [sidcam] Backup Execution Fatal Error

Archived
Reply
Reply

By Jason - August 13, 2012

Hi Sid,

You can make a custom change to the backupDatabase function.

Always back a backup of your CMS file first!

Open up cmsAdmin/lib/database_functions.php

You can change the backupDatabase function around line 635 like this:

// leave tablename blank for all tables
function backupDatabase($filename = '', $selectedTable = '') {
  global $TABLE_PREFIX;
  $prefixPlaceholder = '#TABLE_PREFIX#_';
  
  // allow up to 5 minutes to backup database
  set_time_limit(60*5);
  

  // error checking
  if ($selectedTable != '') {
    $schemaTables = getSchemaTables();
    if (preg_match("/[^\w\d\-\.]/", $selectedTable)) { die(__FUNCTION__ ." : \$selectedTable contains invalid chars! " . htmlspecialchars($selectedTable)); }
    if (!in_array($selectedTable, $schemaTables)) { die("Unknown table selected '" .htmlspecialchars($selectedTable). "'!"); }
  }

Hope this helps

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/