Support

Site Restoration

#16618 Restoring recent backup failed

Posted in ‘Site restoration’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
CMS Type
Other
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a

Latest post by user76995 on Sunday, 30 June 2013 23:09 CDT

user76995
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.11
PHP version: 5.3.26
MySQL version: 5.5.23-55
Host: Hostgator
Akeeba Backup version which took the backup: 3.7.7 or 3.7.10. I don't recall for sure as it was during the time I updated
Kickstart version used to extract the backup: 3.7 (then I tried 3.6)

Description of my issue:
I tried to restore a recent backup taken 6/28/13. I uploaded the archive (.zip) and Kickstart as I have done many times before. The initial extract part ran fine. When it got to the "Angie" part I got an odd, style-free page with what looked like a progress circle spinning in the middle of it and a message that Angie was getting information about my site. That went on for several minutes.

I decided to refresh the page, but got a blank screen. At that point I thought perhaps there is an issue with Kickstart 3.7 so I upload v3.6 and tried it again. I got the same thing.

I then went to a 2 week old backup I had and tried restoring that with Kickstart v3.7. It worked perfectly. That is telling me that there is something wrong with the archive and particularly the installation directory. I decided to experiment.

I took the known good archive from two weeks ago and copied the "installation" directory from that one into the recent backup that failed to restore. Voila.....I got it to work as expected! However, I had some issues with the restored site. It seems like some of the DB tables may have been incomplete or truncated. I am missing many entries in Sobipro that were in that backup. Also, I am unable to even view the list of entries and when I try to "list all" entries I get a 500 error. Strange behavior. The front end seems to function properly from what I have seen so far.

My question would be: is there anything I can do to further troubleshoot this or perform a better restore? I would like to retain my lost Sobipro data and even when I extract the files from the Akeeba Backup archive there are no actual SQL tables to restore. They are some sort of proprietary file format.

Thanks for any help! It would save me a lot of work if I can get this to work!

nicholas
Akeeba Staff
Manager
You took the backup with Akeeba Backup 3.7.8 or a broken package of 3.7.9, which is why we released version 3.7.10 (see release notes).

> I took the known good archive from two weeks ago and copied the "installation" directory from that one into the recent backup that failed to restore. Voila.....I got it to work as expected!

Do that without copying the sql directory and your restoration will succeed.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user76995
Doh! I was on the right track.......I just didn't dig in quite deep enough!

Thanks!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!