Support

Akeeba Backup for Joomla!

#39735 Add "restore DB" to backend

Posted in ‘Akeeba Backup for Joomla! 4 & 5’
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

Joomla! version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by nicholas on Tuesday, 31 October 2023 07:30 CDT

grafixnetz

 

In another ticket you referred me to a page that has this line.
"However, there are use cases where this may not be convenient, e.g. when you want to make a backup available for restoration by a non-technical client who can't reasonably use FTP."

I can change that to "...a non-technical client who can't reasonably import a DB".

Could you consider adding the ability to import a DB alone?
You already do that with full archive. This 'version' would stop after DB restoration.
I have a CRONJOB that backs up my client's DB 3x/day just in case someone does something stupid, like delete important articles or change some important configuration.

As it is now, We normally never need to restore a complete site, but it's the easiest way to restore a previous DB, though a bit of overkill.

Also when I'm working on a DEV site, I frequently backup the DB before 'experimenting'.

A built in feature to restore the DB from within Akeeba backup would be a very welcome update.

 

Thanks

nicholas
Akeeba Staff
Manager

There's a reason why this feature was removed. This backup type has a single, large database dump file. On some servers it causes a lot of trouble trying to restore it. That's why all other backup types which take a database dump do so in smaller chunk files. The only use case for the “Database Only (SQL File)” backup type is when you have a legitimate reason to want to use the command line mysql command, or your host-provided phpMyAdmin / Adminer installation to restore the database. In both cases, there is no time limit, and an ample memory limit to prevent all the issues importing a single, large database dump file would entail. This is something that has to do with how the host configures the server, not something in the programming of either software (from a programming point of view, they are much simpler than the database restoration code in our restoration script). Our limiting factor is the artificial limitations imposed by hosting companies on how we can use their servers.

If you want to allow users to import a database themselves, change the backup type to “All Configured Databases”. This creates a backup archive file, it splits the database dump in small chunks (making it possible to import the database backup efficiently), and includes the restoration script — it's like a Full Site Backup, but without backing up the site's files. That backup type can be used with the Restore feature already present in the backend.

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!