Concrete 5 - Backup Database Failure

Permalink 1 user found helpful
I just started receiving the following error message when trying to execute a Backup Database.

Fatal error: Maximum execution time of 30 seconds exceeded in /home8/dwsteven/public_html/dwsassociates/updates/concrete5.6.0.2/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php on line 712

The backup fails. Does anyone have a fix to this problem?

 
mhawke replied on at Permalink Reply
mhawke
There is a PHP setting called 'max_execution_time' that is probably set to 30 seconds which is too short. As your site gets bigger, things like database backups and even future upgrading processes will take longer than 30 seconds so you need to ask tech support how to raise this value to something like 60 seconds.

You can confirm your 'max_execution_time' value by typing 'Environment' into the Intellegent Search box and having a look about half way down the list.
JohntheFish replied on at Permalink Reply
JohntheFish
If you cant increase the execution time, you may be able to backup from phpMyAdmin
http://www.concrete5.org/documentation/how-tos/developers/backup-a-...

If you want database and file without falling foul of any php limits, have a look at Backup Voodoo.
http://www.concrete5.org/marketplace/addons/backup-voodoo/...
dwsteven replied on at Permalink Reply
So I look at and purchase Backup Voodoo thinking it will solve my problem. And, what do I get another backup error. This time the message reads

"Backup Voodoo failed, as indicated by the individual messages below."
Database backup pass 1 "AJAX error when communicating with server"

Any ideas?



Dudley Stevenson, Managing Partner
Minneapolis – St. Paul, MN Office
Phone: (651) 315-7588
Fax: (866) 794-7314
mailto: Dudley@dwsassociates.com




-----Original Message-----
From: concrete5 Community [mailto:discussions@concretecms.com]
Sent: Wednesday, March 20, 2013 12:18 PM
To: dudley@dwsassociates.com
Subject: Concrete 5 - Backup Database Failure : Building with concrete5
JohntheFish replied on at Permalink Reply
JohntheFish
Please, if you have a problem, open a support request. That way I will be notified rather than relying on my discovering your issue in the forums. Fortunately, today I found this quickly, but without a support request, if I was away from my desk, this could have ended up buried 100 posts down and I could have missed it completely.

http://www.concrete5.org/marketplace/addons/backup-voodoo/support/...

The error message you are seeing is addressed in the documentation, and usually (but not always) relates to a timeout during one step of the backup process.

The solution is to go to the 'custom' configuration option and adjust the backup parameters to do any of:
- increase the ajax timeout
- postpone or reduce an excessively large table
- split the backup over more passes

As to which, that really depends on your environment, your site, how big it is and what addons are installed. If you can open a support request, I will then have your environment details and can provide more detailed guidance.