Support

Akeeba Backup for Joomla!

#29282 Select my site 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 creanova on Tuesday, 27 February 2018 04:38 CST

Tuesday, 27 February 2018 03:26 CST

creanova
Please look at the bottom of this page (under Support Policy Summary) for our support policy summary, containing important information regarding our working hours and our support policy. Thank you!

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:

Hello,
I just bought the Pro version of Akeeba and Admintools because I find your components really excellent.
But less problem:
- My database contains more than ten Joomla website
- I would like to save that the database of my site www.test.fr for example
- I have to select the tables that do not correspond to my site with the option "Exclude tables and / or data"
- I take more than three hours to exclude databases that do not correspond to my site www.test.fr

My question: Do you know a faster method to exclude my tables?

Thanks for your feedback
Good luck

cordially
Edited by creanova on 2018-02-27 03:26 CST

Tuesday, 27 February 2018 04:07 CST

nicholas
Yes, of course I do :) There are two ways, I will give you the one that's fastest and which requires no maintenance in the future. Actually, your use case is exactly what the RegEx Database Tables Exclusion feature was made for. The answer to your question is already documented. But let me present it in an easier, step by step fashion:
  • Go to Akeeba Backup.
  • Activate the backup profile you're interested in.
  • Click on the RegEx Database Tables Exclusion button.
  • Click on New (the Plus button at the bottom of the list).
  • In the first drop-down select Exclude a table.
  • In the text box to the right of the drop down enter the text !/^#__/
  • Click on the disk icon (Save).

The filter definition you created tells Akeeba Backup to exclude all tables whose name does not start with the configured database table name prefix, as defined in your site's Global Configuration. Therefore it excludes the tables of the other nine sites and includes the tables of your site only.

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!

Tuesday, 27 February 2018 04:38 CST

creanova
GREAT, Perfect ????
continue on this path
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!