Support

Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? yes
Have I searched the tickets before posting? yes
Have I read the documentation before posting (which pages?)? yes
Joomla! version: 2.5.8
PHP version: 5.3.10
MySQL version: 5.0.96
Host: (optional, but it helps us help you) Hostgator VPS
Akeeba Backup version: 3.6.12

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 have been running backups on my site on a regular basis. Since about a week ago, the sql files in the backups deem to be incomplete. If I restore a site in a different user acount on the samae server the site I am restoring doesn't load until I manually copy the sql file.

I ran Admintools permission fix and also check the PHP memory limit. I suspect some config change in my server but I cannot pinpoint a problem as I am not aware of any  changes. Can you please advise how the problem can be solved?

Thank you,

Tom

Hello,

I apologize, my session timed out and I didn't notice that I was sending my ticket blank.

I read the previous tickets and the documentation.

My host is Hostgator VPS / PHP: 5.3.10 / MySQL: 5.0.96 / Akeeba: 3.6.12.

Issue:

I have been running backups on my site on a regular basis. Since about a week ago, the sql files in the backups deem to be incomplete. If I restore a site in a different user acount on the samae server the site I am restoring doesn't load until I manually copy the sql file.

I ran Admintools permission fix and also check the PHP memory limit. I suspect some config change in my server but I cannot pinpoint a problem as I am not aware of any  changes. Can you please advise how the problem can be solved?

Thank you,

Tom

Hello Nicholas,

I have done some further exmamination this morning. Here is the fresh info.

So far I have two sites that don't restore:

1. ow.exquison.com
2. ma.exquison.com

1. The backup log I sent yesterday belong to the first case. I back up this site every day and the last backup that works was generated on Jan-4. This is an application that is password protected. (orig: office.ellismoving.com)

2. I attcah the backup log and the sql files pertaining this case. (maexquis_ ma.sql is the incomplete backup sql file) The url of the orig site, which we are building now, is this: metal.exquison.com .

I tried coping an other site on the server and fortunately it did work. So, this is not something the occurs accross the whole server. I will do some more backup-copy test to see if other user accounts are affceted.

Thank you,

Tom

I thing I noticed that many of the file and folder permissions got altered e.g. from 755 to 750. I ran Admintools permission fixes, so the useraccounts in question should have appropriate permissions in the public_html.

Please let me know if you have any advice re how to specify the question I need to ask from Hostgator.

Thanks a lot,

Tom

Oh crap, I am running the backups on all my user account from one "central" useraccount and at this case I missed out the checkmark from the database override, so the backup was made with the wrong sql. This hopefully is a false alarm - I apologize for this.

How about case #1? Do you think the missing session and finder tables has to do with server config?

I will do a backup-restore test for case 2 in the mean.

Thanks,

Tom

So, I restored the metal.exquison.com user account to ma.exquison.com - this time with the right database override setting unfortunately there is still some problem to the sql backup - altough this problem looks to be different to case 1.

Please see atached the backup log and the sql files. (maexqui_ma is the backup sql) The difference between the orig and the backup sql seems to be in lines 509, 626, 7784, 7794, 7796, 9653, 9654.

In these lines of the backup sql there are references of a prefix (k9yqn), which was the prefix of the orig sql database. I changed it by Admintools to the current prefix a few days ago.

Thanks,

Tom

Hello Nicholas,

I apologize for not giving you staighforward enough info.

If you go to the restored site -  ma.exquison.com - then this is the error message:

Table 'maexquis_ma.k9yqn_session' doesn't exist SQL=INSERT INTO `k9yqn_session` (`session_id`, `client_id`, `time`) VALUES ('64442d5da3acc2c98c61d88d35c87dc4', 0, '1358582170')

Again, if I manually copy the sql file over from the orig user account to the new user account then that solves the problem.

BTW, you asked about the override setting. The way I am using your Akeeba Backup is that I have one joomla installation on my server with Akeeba Backup and I am using this installation to backup all the rest of my user accounts on the server. This lets me manage all my Akeeba crone jobs from one useraccount and there is only one place I need to refresh Akeeba. Pls let me know if you think this is not the way I am supposed to use Akeeba - I though this was a pretty kickass feature!

Enjoy the weekend,

Tom

Hello Nicholas,

I have to apologize for sending you false alarm.

It turns out that in both cases the prefix wa not correct in the Akeeba backup config. In one case, I chnaged the prefix of the given site in the Admintools and I forgot about it. In the other case, my colleague created a new sql database with a new prefix that I was not told about... It made the situation worse that I noticed that the backups were not running properly at the same time leading me to believe that it was a problem across the whole server.s

I am terribly sorry for taking up your time with this & really appreciate your attention.

Have a great week,

Tom

p.s.: The Akeeba centralize backup feature is totally cool!