Hey bjcohn,
It sounds like your server is running out of resources before the backup can complete.
Could you try running a database only backup, does that then complete?
Thread Starter
bjcohn
(@bjcohn)
Thanks Tom for your response.
I just did two “run now” manual database ONLY backups. They finished in seconds, but they are about 7 megs short of a full sql backup.
Thread Starter
bjcohn
(@bjcohn)
Sorry, last reply was in error.
When I downloaded the zipped database backup, it expanded to a normal size?
The database only backup worked ok. Sorry, I am not used to seeing that database file zipped up, it is usually left behind unpacked.
Thread Starter
bjcohn
(@bjcohn)
I did a files only manual backup and looking at the files, It looks complete, but it left behind this file only (no error file)-
.schedule-1371658313-running and of course, doesn’t show in the control panel as being there.
There is also a response from the server:
500 Internal Server Error
Internal Server Error
The server encountered an internal error or
misconfiguration and was unable to complete
your request.
Please contact the server administrator
and inform them of the time the error occurred,
and the actions you performed just before this error.
More information about this error may be available
in the server error log.
Apache Server at riovistacity.com Port 80
Thread Starter
bjcohn
(@bjcohn)
I am sorry to keep adding more info.
After I closed the Server Error message, it deleted everything in the backup folder. I assume this is normal, since it wasn’t a complete backup, although it did look like the correct file size.
Do you have access to your error logs, it would be good to understand what caused the 500 server error.
Thread Starter
bjcohn
(@bjcohn)
No, unfortunately I don’t have access to the server logs.
Thread Starter
bjcohn
(@bjcohn)
Two of my backups work without error and are on the same server as the problem child.
I normally don’t get a 500 error.
The problem backup is about 1.5 gigs zipped compared to the other two which complete without a problem and are about 150 megs zipped.
The bottom line is that after running a database and files backup, if I delete the “running file” then it shows as being backed up in the control panel. When I unzip it, it seems to be fine for all the files. I then have a separate backup of the files and a separate .sql file. I can always zip them together myself, if I want to.
I just wish your program could complete its process?
Could be worse, I guess.
Hmm, sounds like the backup is failing at the point it adds the database to the backup zip, it’s likely that your larger site is simply causing an out of memory limit or script timeout on your server.
Like you say you could zip them together, or have 2 schedules, one for database only and one for files only.
