Support

Site Restoration

#40096 How do I make sure all files and tables from the previous installation are removed.

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
Joomla!
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a

Latest post by tampe125 on Monday, 15 January 2024 09:24 CST

pjdevries

I am in the testing phase of a project and have to restore a previous version of the site, without an update package applied. The update package adds files and a table that are left behind after restoring the previous version. Both result in errors when accessing the site. For removal of the table I tried the existing tables "Drop All" in the database restoration advanced options. This fails because there are some database constraints in place that prevent it. I have no clue how to remove the files that cause errors when left behind.

Is there any way to solve this, without having to ask the testers to manually remove everything before restoration?

tampe125
Akeeba Staff

Hello,

when restoring the backup, Akeeba Backup will not delete any "extra" files (ie files that were added after the backup). You have to manually delete them.

When you restore the database, please double check that the option "Suppress Foreign Key checks" is flagged: https://www.akeeba.com/documentation/akeeba-backup-joomla/angie-installers.html#angie-common-database

This should let you drop tables even if they are linked by foreign indexes.

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!

pjdevries

Thanx for the reply.

When you restore the database, please double check that the option "Suppress Foreign Key checks" is flagged: https://www.akeeba.com/documentation/akeeba-backup-joomla/angie-installers.html#angie-common-database

This should let you drop tables even if they are linked by foreign indexes.

Because that setting is the default, I am pretty sure it was flagged all of the times. It does not seem to do what is expected though.

when restoring the backup, Akeeba Backup will not delete any "extra" files (ie files that were added after the backup). You have to manually delete them.

Can you think of a way to automate this?

tampe125
Akeeba Staff

Yes, you can delete those extra files, but please be aware that the script will delete everything and then perform the restoration. If you perform the restoration using Kickstart, there's an option to wipe everything before doing the extraction. With the integrated restoration, you have to enable this feature in the Options page, then you can select it before restoring a backup.

For database data, during the restoration, in the Database page, you can select With Existing -> Drop All.

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!

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!