Support

Site Restoration

#35807 Restoration of site's main database failing

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 on Saturday, 16 October 2021 20:17 CDT

pmarkoni

Hi there. I'm trying to publish an old site so that my client can retrieve information from it to put on their new site.

I have restored many times before but this isn't working - please see attached screenshots.

I assume I have some of the information wrong. I tried using your extraction tool but I think you no longer support it.

Is there anyway I can access the site's information please?

Many thanks,

Mark.

tampe125
Akeeba Staff

Hello,

what's the error reported? I can only see your db information and the site URL. Do you get an error while restoring the data, or when ANGIE tries to connect to your database? Is the database already created?

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

pmarkoni

Hi Davide,

Thanks for your fast reply. The error code was on one of the screenshots I attached (attached again here).

The error comes when restoring the main database. I have successfully done it before on this site but it stopped working a few weeks ago. It is an old site that was called bhpgc.com but the client has moved away.

I must have the information somewhere but in the meantime is it possible to retrieve text from the site without publishing it (from the .jpa file)? Thank you.

Mark.

tampe125
Akeeba Staff

When you get an access denied error, it means that we can not authenticate with the database. This could happen because credentials are invalid (any of host, username, password or db name) or the database does not exist at all.

You can recover the contents of the sites, they are inside the installation/sql folder. However, those are very hard to read for humans, since they are meant to be feed directly inside the database. 

My suggestion would be to try to make the database work, if that's not possible, restore it locally using a local webserver like XAMPP or MAMP.

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

pmarkoni

Thanks Davide, I'll give that a go.

Mark.

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

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!