Support

Site Restoration

#11548 Using Extract Wizard - How to restore manually the 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

Chacapamac


Description of my issue: Extract 3.3 - Backup Akeeba Backup Core3.3.11 (2012-01-02)

I got multiple .s0 files - databases.ini and Joomla.sql

Using phpmyadmin to restore?

nicholas
Akeeba Staff
Manager
The User's Guide has everything you need. Take a look at the "Unorthodox: the emergency restoration procedure" chapter.

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!

Chacapamac
The only thing at didn’t look at....

It will be great if the package include a complete zip or compress database without the fuss.

That will permit an easy manual restore...

thanks.

nicholas
Akeeba Staff
Manager
And it would make the automatic restoration impossible. If you want to manually restore your databases, you can always create a database only backup.

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!

Chacapamac
I was thinking more at keep the same files for the automatic backup and an extra complete zip database backup in the install/sql (or other) folder just in case.

Like that you have both an easy automatic and manual way in the same JPA file.

nicholas
Akeeba Staff
Manager
I've seen sites (like mine) where the database can be around 80Mb and the rest of the files 30Mb. The total backup archive size is about 80Mb. If I dump the database twice, not only the backup will take forever to complete, it will almost double in size. All of that for what? The off-chance that someone wants to do a manual restoration? Akeeba Backup IS NOT designed for manual restoration. It would beat the purpose. If you want to do a manual restoration, you have three choices:
- Follow the emergency restoration instructions
- Use a database backup only profile
- Use phpMyAdmin or other tools to manually dump your database
I will not screw up the major benefit of Akeeba Backup just because someone, sometime might need to do something which is against the way Akeeba Backup is supposed to work. It would be more than absurd, it would be extremely stupid to ruin my software in that way.

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!

Chacapamac
You are absolutly right β€” I have a site with a 90mb database and it will probably double the chance of failing by php timeout.

β€œUse a database” only profil, I need to try !!!.

Can I attached cron job to both a jpa backup and a database profile?

nicholas
Akeeba Staff
Manager
You can create two CRON jobs, one for a full site backup and one for a database only backup. Make sure you schedule them adequately apart so that one doesn't start while the other is still running (that would cause a big problem!)

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: 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!

Summer vacations: Our support will be closed for replies and new tickets from August 6th to August 21st, 2022 due to summer vacations.