Support

EXTREMELY IMPORTANT: Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 2Mb, please upload it on your server and post a link to it.

Description of my issue:
Hi,
It's not an issue but a problem with tables exclusion: Akeeba backup for Joomla! creates a list of tables to be excluded but I need only a checkbox to backup only site tables, as it works in LazyDbBackup I am maintaining.
My problem is that as soon as another website ont the database adds one or some tables, it's necessary to exclude them in all other website Akeeba backup using the same database. If I don't perform this step I will backup tables of other websites that will replace the good ones when I will restore my main website.
For example a friend of mine is using on a shared server one database for a lot of Joomla! websites: it's not possible to exclude one by one the tables of other website, because their number is too high.
Is it possible to add a checkbox to say "I only want to backup the site tables and none of the other" with the actual default values (eg. excluding data from cache)?
I hope you understand!
Thanks in advance,
Robert

Sorry for the title! I wanted to write Insert only site tables!

On the Database Tables Exclusion screen, use the green Exclude non-core tables button at the top of the screen. This will exclude tables that do not have the table prefix defined in Global Configuration.

This will not work if you have a forum or other "add on" that you need to include in the backup. You will need to exclude the tables every time the tables in the database change. Akeeba will back them up unless they are explicitly excluded.

Thanks Dale but it's that I do every time. I'm using Akeeba backup for a long time and do that.
But I don't want to exclude on every website using the same database each time I add something on another website, and if there are a lot of tables (a lot of host give the rights to have a database up to 1GB or more), exclusion will fail or take an extreme long time on each website to perform these exclusions.
For example, if I add a new site using the same database as one or more others, I will need to open each other sites to exclude these new tables, and do it as soon I add a new extension on this new site! What a lot of time loosed then!
If I miss, I will embed tables that I don't want: a list of excluded tables is not a good idea, as this list can often be incomplete and restoration will restore table that don't need to be.

There is no better way to do it. And there is no way to automate the process for many websites.

Do you have the option of using different databases for each site? Some hosts allow this, others limit you to one database. Using separate databases for each site avoids the problem of having to update your excluded tables.

For my own use, I have a lot of databases and use one for each site, but when I will renew my contract, I will have only 10 databases, for my own websites (4) and 3 demos, and for all my test and clients sites in construction. At this moment, I will need to use many sites on each database. :(
And numerous clients have only one database.
So If it could be possible to add a new functionnality to Akeeba backup for exclude external tables without listing them, it would be better, IMHO.
As I said, LazyDbBackup do that: you can backup either the whole database or only the site tables with a single Yes/No button in its options. It's basic but convenient: if you set to Yes, LDB will read configuration.php for knowing the prefix and include only these tables.

I'll flag this ticket for Nicholas to review the feature suggestion.

(sigh) I hate it when Nicholas catches me with an RTFM. :-(

You can't do what you want through Exclude Tables, but you can do exactly that with the RegEx filter. See the documentation here for more details: https://www.akeebabackup.com/support/site-restoration/22377-links-with-my-old-site-description-after-migration.html#p123748.

Thanks Dale!

You are welcome!