Support

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

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.

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.