Support

Akeeba Backup for Joomla!

#30224 DB only backup with multiple DB - how to use the result

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 on Wednesday, 10 October 2018 17:17 CDT

lcollong
Hi,

I use cron setup to generate a full site backup (very standard) every week and a sql tables only backup every day.
My setup include a second database (real separate DB with different connection and access url). I used the multiple db parameters and all what I want is done. Including remote copies of all on a separate server/site. Thanks to this fantastic tool.

However, my second profile backup (DB only) seems to have to be JPA in order to include tables from the second DB. I can't use the second option which produces a standard .sql file.

What such a JPA file is intended to do ? It includes installation directory and angie framework. Why ? The idea is to restore DB only on an existing Joomla ?
I would prefer to have regular sql files. One for each DB. As I have a special process running from the second server in order to let user recover some data. It will be easier to have only one sql files rather than extract the archive, digging the directories, find the sql and sxx files, replace the #__ syntax, etc....

Is this already possible ? Should it be a future feature ?

Thanks

dlb
There isn't any way to get just the databases in sql files. The "All configured databases" that you're using is the correct way. That does include code to restore the databases and the prefix in the main database is replaced with #__.

The sql files are always located in /installation/sql in the backup archive. You have some control over the split sizes of the sql file in the Configuration settings for the database dump. You can't make it too large because even under phpMyAdmin you're subject to PHP time limits when doing a restore. The easiest way is just to use the restore script and let it do the work for you.


Dale L. Brackin
Support Specialist


us.gifEnglish: native


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


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

System Task
system
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.

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!