Support

Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? yes
Have I searched the forum before posting? yes
Have I read the documentation before posting (which pages?)? yes
Joomla! version: (1.7.3)
PHP version: (unknown)
MySQL version: (unknown)
Host: (optional, but it helps us help you)
Akeeba Backup version: (3.3.1)

EXTREMELY IMPORTANT: Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 2Mb, please upload it on your server and post a link to it.

Description of my issue: I was successfully running Akeeba backup for some months. During the last week or two backup has not worked. The initial problem was that it started, gave messages saying that all the files were being backed up, then froze when it got to updating statistics. I tried several times and waited 30 minutes longer, but nothing happened. I tried various remedies in the documentation, such as re-running the config. wizard, re-saving the file, but same result. I then tried just backing up the data base and got the message 'Could not move the SQL dump to its final location'. Even though I thought I had previously backed up files I cannot see any in the backup directory.

Sorry, it was a mis-typing. I am actually running 3.3.11.

I have tried several things.

1 Gone through the system and removed tmp files as well as old backups. Strangely, there were files from the weekend labelled backup, even though the backup process never finished successfully. These were files of 400MB. My Joomla database is almost 800kb, so that seems to be the database plus files, as configured.

2 Checked my disc quota on the server. I am at about 7%. Nevertheless, I have asked my service provider to check the disc space as there were space problems with other applications over the weekend.

3 Changed the parameters to set 2 and tried a full backup. It froze as before when reaching the gathering statistics stage. Log file 1 attached.

4 Tried srunning just a database backup with set 2. 'Could not move SQL' message occurred. Log file 2 attached.

5 Tried running backup with set 1 and set to just database. Same error as in 3. Log file 3 attached.

Nicholas

Before I create more work for you you might like to read this reply from my web hoster.

"We run a program to automatically stop SQL queries that take too long to run. Currently it's 20 seconds, if a query runs for more than 20 seconds it'll be killed (as long as it's not a UPDATE/DELETE/INSERT query). That program hasn't been running since Thursday, however, so if you've been having backups failing after that it'll be something else. The next thing to look at is how long PHP processes can run for which is 30 seconds. If it takes that long (or longer) it may be interrupted."

Should I set any of the parameters differently to take account of this, or do you still want me to end you the information by PM?

Thanks
Stuart

Thank you for your fantastic support. That installation is now working. I have never come across such speedy and comprehensive support.

Stuart