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

Posted in ‘Kickstart / Backup Restoration’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Tuesday, 03 September 2019 19:45 CDT
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
Custom Fields
Joomla! version (in x.y.z format) 3.9.11
PHP version (in x.y.z format) 7.3.8
Akeeba Backup version (x.y.z format) 6.6.0
Kickstart version (x.y.z format) 6.0.1
todd.herman@toddherman.com
Wednesday, 04 September 2019 00:40 CDT
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



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



nicholas
Wednesday, 04 September 2019 15:39 CDT
This worked - thank you!
todd.herman@toddherman.com
Thursday, 05 September 2019 00:41 CDT
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



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



nicholas
Saturday, 05 October 2019 17:17 CDT
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.
system
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.

Support Information

Working hours: Typically we work Monday to Friday, 9am to 7pm Cyprus timezone (EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets, but we cannot respond to them, outside of our working hours.

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!

Cookies Notification - Action required

This website uses cookies to provide user authentication and improve your user experience. Please indicate whether you consent to our site placing these cookies on your device. You can change your preference later, from the controls which will be made available to you at the bottom of every page of our site.