Support

Akeeba Backup for Joomla!

#35397 Only Backup Certain Tables on a very large database

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 Friday, 16 July 2021 20:17 CDT

nphic

Folks,

This is not a problem, but a usage question. I want to backup specific tables from my database. I have over two hundred tables in my database. Is there a way to just select what I want to backup versus selecting what I do not want to backup. I'm trying to export just the community builder tables.

Thanks in advance for your help!

Joe

nicholas
Akeeba Staff
Manager

You could use the regular expressions filters to do that. But first, you need to invert the question in your head to make more sense in this context. You want to find out how to exclude all tables EXCEPT FOR the few tables you want to back up. Assuming that the tables start with #__community (remember that #__ is how the table name prefix is denoted internally in Joomla, therefore in Akeeba Backup as well) you need something like

!/^#__community_/

The exclamation mark means "invert this rule". The slashes are the delimiters inside of which we place the rule. The caret means "starting with". Therefore this rules means "every table whose name does not satisfy the criterion ‘begins with #__community_’". There you have it :)

For what it's worth, an example similar to this can be found in the documentation.

I hope this helps!

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!

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!