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