Support

Akeeba Backup for Joomla!

#38427 Option Akeeba Backup Pro

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
Latest Version
PHP version
latest
Akeeba Backup version
latest

Latest post by nicholas on Sunday, 29 January 2023 12:45 CST

ReneSchouten

I use the PRO version of Akeeba Backup. I have the following question about this: I have a website (domain name) online, with a database. Under this domain name I also have a 2nd website (under a SUB domain), including a 2nd database. If I make a backup of my website (domain name) with Akeeba Back Up PRO, he will also include the SUB domain in this backup, including the 2nd database.

nicholas
Akeeba Staff
Manager

When you have two (or more) sites' databases in a single MySQL database you need to use the RegEx Database Filters feature. As noted in the end of the documentation page I linked, you can create a new regex filter with the content

!/^#__/

This tells Akeeba Backup to skip over any table which does not belong to the joomla installation being currently backed up.

Merely as an aside: For site performance and security reasons it is very strongly recommended that you create one MySQL database per site. While Akeeba Backup can work around multiple sites' database tables occupying space in the same MySQL database this is far from being your only problem. Versions of Joomla released in the last decade (3.4 and later) use the InnoDB table format for most tables. This format shares a single data file across all tables. Having the InnoDB tables of two sites share the same database increases the chance of a read/write lock when accessing database data which can have a performance impact on your site, especially if both sites have a fair amount of traffic. Moreover, by sharing the same MySQL database you have a security issue. If one site gets compromised (hacked) then BOTH sites are hacked since each site can access the other site's tables, including the tables which handle users and extension configuration. This is merely for your information, so you can make informed decisions about the performance and security of your sites.

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!

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!