Support

Akeeba Backup for Joomla!

#8855 All databases included?

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 nicholas on Saturday, 30 April 2011 12:59 CDT

Dix
Mandatory information about my setup:

Have I searched the forum before posting? Yes
Have I read the Troubleshooting Wizard before posting? Yes
Have I read the documentation before posting? Yes
Joomla! version: 1.5.23
PHP version: 5.215
MySQL version: 5.1.52
Host: hg
Akeeba Backup Professional version: (unknown)

EXTREMELY IMPORTANT: Please attach your Akeeba Backup log file in order for us to help you with any backup or restoration issue.

Description of my issue:

First, I'm a new Pro customer. The products, documentation and support are some of the best I've ever found. I've installed on 10 sites with S3 backup so far and all work great.

I think (and hope) the answer to this question is yes, but I need to verify. A client I just took over has a bit of a jumbled site. It's all joomla, though. The question is whether when I do a complete backup of the main site, I capture every domain file set and database on the server under this one cpanel. Here's what the site has:
1. Some addon domains don't have separate DBs; they are tables within the main joomla db.
2. Some are normal addon domains with their own separate DBs under the same cpanel.
3. There is one WordPress db that doesn't seem to be tied to anything (but you never know).

So will I, with one backup, capture everything I need to perform a total restore for all these related sites if needed?
Thanks.

nicholas
Akeeba Staff
Manager
Thank you for your kind words!

The answer to your question is "it depends".

First, the databases. If all sites' databases are inside the one and same database (they just use different prefixes) you need do nothing special. If not, you just need to use the Multiple Database Definitions tool in Akeeba Backup's control panel page to include all the databases whose connection information is different than your Joomla! site's database connection information.

Them the files. If all the add-on domains are subdirectories of your Joomla! site's root directory, you need to do nothing further; they will be automatically included unless you explicitly exclude them. If each add-on domain uses a different directory above the Joomla! site's web root, you have to use the Off-site Directories Inclusion button in Akeeba Backup's control panel page to include them in the backup.

I hope that makes sense :)

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!

Dix
Thanks, nicholas.

After adding a database, I downloaded a copy of the backup and unzipped it using your tool. I opened it to see if the extra database was there. Inside installation->sql I found what seemed to be sections of the two databases. The original was in the form joomla.s01, joomla.s02, etc. The other was in the form 1B6H1234-[name of db].s1, etc. So it looks as if both databases were captured. Is this correct?

nicholas
Akeeba Staff
Manager
Yes, that's correct! You have set it up correctly.

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!