Support

Site Restoration

#41100 Where are my backups please

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

Latest post by nicholas on Tuesday, 10 September 2024 00:53 CDT

barraclm

My hosting company has screwed up (they admit it). They are supposed to do daily backups, but haven't because deprecated.php was too big, and they didn't tell me.

I have attached the latest akeeba backup log file (about 1 month old).

I think that all my files are there but the database has either disappeared or been corrupted.

Are you able to tell me what the qualifier for my database is so that I can look for it on the host. Also, is there a way to just restore the database from the backup?

Regards - Michael Barraclough

 

System Task
system
The ticket information has been edited by Michael Barraclough (barraclm).

System Task
system
The ticket information has been edited by Michael Barraclough (barraclm).

nicholas
Akeeba Staff
Manager

The backup archives are where you have configured them to be stored. By default, that's the administrator/components/com_akeebabackup/backup directory. If you have set up the backups to be transferred to an off-site backup location then the backups will be there as well, or instead of the backup directory.

Please note that your backup log file was not uploaded, that's why I can only give you this generic reply. If you could please put it in a ZIP file and attach it to your next reply I can check what the log file says.

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!

barraclm

Hi

Thank you for your response and I apologise for not uploading the log file (which should now be attached).

I can confirm that

  • all the Joomla files appear to still be in place
  • there are 3 Akeeba Backups, the latest being 30 July 2024. They are in the default position in the file system
  • the database associated with the site is completely gone

I am assuming that I am able to extract the database from the backup and restore that. I have no experience of doing this and would appreciate being pointed at a guide to help me through this process.

Michael Barraclough

nicholas
Akeeba Staff
Manager

First, please confirm that you have the .jpa, .jps, or .zip backup archive file in the default directory in the file system. If you only see a .php file, that's just the log file.

Then, download Kickstart Core from our Download page (there's a link to it at the top of every page of our site).

Extract the ZIP file you downloaded on your computer.

Upload kickstart.php to your site's root.

Rename your .htaccess file to .htaccess.bak. You may have to click on "Show hidden files" or something similarly titled in your FTP/SFTP software, or your hosting control panel's file manager to see this file; all files whose name starts with a dot are hidden files in Linux.

Make sure you have the connection information to your database. If unsure, ask your host. If you are creating a new database from scratch please make sure that you create a database, create a database user, and give the database user full permissions to the database.

Run Kickstart by visiting the /kickstart.php URL on your site.

Kickstart should automatically find the backup archives. If not, check the Archive directory option at the top of Kickstart page. Append (add to the end of what is already there) /administrator/components/com_akeebabackup/backup and click the green Reload button.

The Archive file drop-down will show you the available backups. Select the backup you want to restore.

Scroll all the way down and click on Start.

The rest of the process is what is shown in https://www.akeeba.com/videos/1212-akeeba-backup/1618-abtc04-restore-site-new-server.html.

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!

barraclm

Thank you for the very clear instructions and accompanying video. I can confirm that the backup files are there

site-michaelbarraclough.uk-20240730-095907bst-IQvuaCYifUuR67Gv.j01 (2Gb)

site-michaelbarraclough.uk-20240730-095907bst-IQvuaCYifUuR67Gv.j02 (2Gb)

ite-michaelbarraclough.uk-20240730-095907bst-IQvuaCYifUuR67Gv.jpa (1.8Gb)

 

Please could you confirm that this backup file only contains the database, and if not, what else?

Please could you also confirm that if I change the database name as part of the re-installation process do I need to change the configuration.php as well.

Regards - Michael Barraclough

nicholas
Akeeba Staff
Manager

Your backup archive contains your database and your site's files, along with the restoration script.

If you want to only restore the database, it is possible, but any updated extensions might not work because there will be a discrepancy between the code running (provided by files, newer) and database structure (restored from the backup, older). Therefore, I recommend restoring the entire backup as I told you.

As you can read in the documentation and see in the video I linked you to the restoration takes care of restoring the database and re-configuring your site (change the configuration.php file as necessary).

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!

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!