Support

Site Restoration

#31708 Akeeba Backup Site Restoration Script Errors Out on Restoring Main Database

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, 05 October 2019 17:17 CDT

Tuesday, 03 September 2019 19:45 CDT

[email protected]
After successfully backing up my site on WIMP stack (Joomla 3.9.11, MySQL 5.5, PHP 7.3.0), I used FTP to drop backup JPA and kickstart.php (from kickstart-core-6.0.1.zip) to new LAMP stack (versions, above), and successfully extracted the archive. When it was time to use the installer, I set "Connection Info" as follows:

Database type: MySQLi
Database server host: localhost
User name: adminer
Password: ********
Database name: ibdata1 (I also tried joomla_site_db - no difference)
Database table name prefix: todj36_

I used defaults under "Advanced Options" then pressed "Next" button.

Immediately after that, I received "Database error processing line 0" - full text of error and query in attached .TXT.

Also attached - snips of connection info dialog and error message box.

I am in Greensboro, NC, US - Eastern time zone. On Wed, Sep 4, I'm available 8:30 am to 12:00 pm, and then again 1:30 pm to 6:00 pm.

Thank you,
Todd Herman

Wednesday, 04 September 2019 00:40 CDT

nicholas
It looks like your backup contained a MySQL VIEW which references a table that does not exist. Presumably the table was removed after the VIEW was created. This means that the VIEW can still exist in the database and get backed up but cannot be used and its backup cannot be restored. That is to say, it was not used by your site, it causes problems and we can safely skip its restoration.

On the database restoration page (your first PNG screenshot) you need to unselect (clear) the "Stop on CREATE error". This tells ANGIE to ignore the error which occurs when trying to create the problematic VIEW and continue with the restoration.

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!

Wednesday, 04 September 2019 15:39 CDT

[email protected]
This worked - thank you!

Thursday, 05 September 2019 00:41 CDT

nicholas
You're welcome!

We apologize for taking you through a wild ride of red herrings until we could help you. Dale misunderstood your original post. He was under the impression that the archive extraction fails. Before he went on short vacation he realized his mistake, asked me to take a look and told me he's sorry.

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!

Saturday, 05 October 2019 17:17 CDT

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!