Forums

Backing up database - I get Internal Server Error 500

Permalink 1 user found helpful
Hi

When I run BackUp in Backup & Restore I either get Internal Server Error 500 (I am responsible for our servers) or it just hangs.

After researching these forums, I went to PHPMyAdmin and exported a .sql file which I then uploaded into the Files/Directory folder.

When I check the back up files in Backup & Restore, the backup .sql is there but it shows a date and time of 01-01-1970 01:00:02

This does not inspire any confidence that should I need to restore my database it will be OK!

The size of my database is 27.2Mb and the size of my website is 398Mb and growing...

Can anybody advise or reassure me on this?

Regards

Steve

P.s I am using Version 5.4.2.2
 
exchangecore replied on at Permalink Reply
exchangecore
Just a thought, it could be that your backup job is timing out when you run it from the web page. Check to see what your max_execution_time is in your php.ini file. Odds are for a 400mb database you could need a couple minutes to backup on a slow server.
JohntheFish replied on at Permalink Reply
JohntheFish
If upping the time does not work for you, have a look at
http://www.concrete5.org/documentation/how-tos/developers/backup-a-...
for some more options.

There is also Backup Voodoo
http://www.concrete5.org/marketplace/addons/backup-voodoo/...
blokeybloke replied on at Permalink Reply
Hi Guys

Thanks for your replies, I changed the max setting, but did not work, so went down the PHPMyAdmin route.

Thanks

Steve