Support

Akeeba Backup for Joomla!

#16720 Hybrid Backups or Separate?

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 Tuesday, 09 July 2013 07:00 CDT

user55161
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: (2.5.11)
PHP version: (5.3.25)
MySQL version: (5.5.31-MariaDB)
Host: (hostpapa.co.uk)
Akeeba Backup version: Akeeba Backup Professional 3.7.10 (2013-06-29)

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:
I have a Joomla site acting as the main top-level (wrapper) to a Joomla+Moodle site. This question is not about Moodle (it could be any software additional to joomla) but about the best approach for restoring the entire site - or part of the site) should I need to.

I have successfully configured five other Joomla sites and have left this one, the most tricky, till last.
Joomla holds user account details, payments & products (via Hikashop) etc. Moodle is used simply as the content-driver for providing courses and questions. The two are connected via a software link called Joomdle whose job is to synchronise users on both Joomla and Moodle and to synchronise Courses back to Joomla so that they appear as Hikashop products that can be purchased. The only important thing is that both are closely integrated to the extent that a new user account and payment in Joomla will lead to course activity in the Moodle; conversely new new and changed courses in Moodle are reflected back to Joomla as new or changed products. The only other things worthy of note is that Moodle is not as easy as Joomla to restore to a different site/domain without changing the configuration; Moodle has an important and often-changing data directory above [SITEROOT]. We'll call the latter "moodle-data". It needs to be backed up frequently.

On other sites configured so far, I have used full site and database-only backups. My question is one of best approach and how you might analyse the problem for this hybrid Joomla+Moodle site given your experience.

Joomla and Moodle use separate databases. The Joomla database backup is implicit in both full and database-only backups providied the database override has not been changed. But both databases are so closely linked that it seems best that a backup of a Joomla database should also include a backup of Moodle's.

I have been trying to think of the conditions that would force a restore: Database corruption - more than likely to be just one DB, but corruption of both is possible because of Joomdle. Hacking: likely to be one or the other because of a vulnerability in one or the other. Change of hosting provider or relocation: everything.

Would you a) keep the joomla and moodle profiles totally separate so that either (or both) can be restored independently when needed? OR
b) integrate Joomla and Moodle backups into the same profile so that restoring one restores the other?

If b) a typical database-only backup would be JoomlaDB + MoodleDB with the Joomla DB included by default; a typical "light" backup would be JoomlaDB + MoodleDB + moodle-data. Again, if b) would a typical full backup be Full backup (not site + files) + MoodleDB + Moodle-files + moodle-data or would you use site + files?

Thanks,
Ric

nicholas
Akeeba Staff
Manager
Akeeba Backup is designed to only back up and restore Joomla!. I cannot give a recommendation that has to do with a non-Joomla! product. I would back up everything: Joomla! (it's backed up automatically with a full site backup profile), Moodle's database (using the Multiple Database Definitions feature) and the data directory (using the Off-site Directory Inclusion feature in Akeeba Backup). Restoring is a bit of a pain, as you'll have to manually move the data directory from the external_files directory where it is restored to its real location. But if you want to restore only one of the two databases you can; the restoration script (ANGIE) is fully capable of skipping a database if you do not want to restore it.

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!